1. Tables and Views for SCM
  2. CJM_XLA_CUST_ADJUSTMENTS_V

CJM_XLA_CUST_ADJUSTMENTS_V

Details

  • Schema: FUSION

  • Object owner: CJM

  • Object type: VIEW

Columns

Name

CUST_MANUAL_ADJUSTMENT_ID

CUST_PGM_MAN_ADJ_ATRB_CAT

CUST_PGM_MAN_ADJ_ATTRIB_1

CUST_PGM_MAN_ADJ_ATTRIB_2

CUST_PGM_MAN_ADJ_ATTRIB_3

CUST_PGM_MAN_ADJ_ATTRIB_4

CUST_PGM_MAN_ADJ_ATTRIB_5

CUST_PGM_MAN_ADJ_ATTRIB_6

CUST_PGM_MAN_ADJ_ATTRIB_7

CUST_PGM_MAN_ADJ_ATTRIB_8

CUST_PGM_MAN_ADJ_ATTRIB_9

CUST_PGM_MAN_ADJ_ATTRIB_10

CUST_PGM_MAN_ADJ_ATTRIB_11

CUST_PGM_MAN_ADJ_ATTRIB_12

CUST_PGM_MAN_ADJ_ATTRIB_13

CUST_PGM_MAN_ADJ_ATTRIB_14

CUST_PGM_MAN_ADJ_ATTRIB_15

CUST_PGM_MAN_ADJ_ATTRIB_16

CUST_PGM_MAN_ADJ_ATTRIB_17

CUST_PGM_MAN_ADJ_ATTRIB_18

CUST_PGM_MAN_ADJ_ATTRIB_19

CUST_PGM_MAN_ADJ_ATTRIB_20

CUST_PGM_MAN_ADJ_ATB_N1

CUST_PGM_MAN_ADJ_ATB_N2

CUST_PGM_MAN_ADJ_ATB_N3

CUST_PGM_MAN_ADJ_ATB_N4

CUST_PGM_MAN_ADJ_ATB_N5

CUST_PGM_MAN_ADJ_ATB_N6

CUST_PGM_MAN_ADJ_ATB_N7

CUST_PGM_MAN_ADJ_ATB_N8

CUST_PGM_MAN_ADJ_ATB_N9

CUST_PGM_MAN_ADJ_ATB_N10

Query

SQL_Statement

SELECT

MANUAL_ADJUSTMENT_ID CUST_MANUAL_ADJUSTMENT_ID,

ATTRIBUTE_CATEGORY CUST_PGM_MAN_ADJ_ATRB_CAT,

ATTRIBUTE_CHAR1 CUST_PGM_MAN_ADJ_ATTRIB_1,

ATTRIBUTE_CHAR2 CUST_PGM_MAN_ADJ_ATTRIB_2,

ATTRIBUTE_CHAR3 CUST_PGM_MAN_ADJ_ATTRIB_3,

ATTRIBUTE_CHAR4 CUST_PGM_MAN_ADJ_ATTRIB_4,

ATTRIBUTE_CHAR5 CUST_PGM_MAN_ADJ_ATTRIB_5,

ATTRIBUTE_CHAR6 CUST_PGM_MAN_ADJ_ATTRIB_6,

ATTRIBUTE_CHAR7 CUST_PGM_MAN_ADJ_ATTRIB_7,

ATTRIBUTE_CHAR8 CUST_PGM_MAN_ADJ_ATTRIB_8,

ATTRIBUTE_CHAR9 CUST_PGM_MAN_ADJ_ATTRIB_9,

ATTRIBUTE_CHAR10 CUST_PGM_MAN_ADJ_ATTRIB_10,

ATTRIBUTE_CHAR11 CUST_PGM_MAN_ADJ_ATTRIB_11,

ATTRIBUTE_CHAR12 CUST_PGM_MAN_ADJ_ATTRIB_12,

ATTRIBUTE_CHAR13 CUST_PGM_MAN_ADJ_ATTRIB_13,

ATTRIBUTE_CHAR14 CUST_PGM_MAN_ADJ_ATTRIB_14,

ATTRIBUTE_CHAR15 CUST_PGM_MAN_ADJ_ATTRIB_15,

ATTRIBUTE_CHAR16 CUST_PGM_MAN_ADJ_ATTRIB_16,

ATTRIBUTE_CHAR17 CUST_PGM_MAN_ADJ_ATTRIB_17,

ATTRIBUTE_CHAR18 CUST_PGM_MAN_ADJ_ATTRIB_18,

ATTRIBUTE_CHAR19 CUST_PGM_MAN_ADJ_ATTRIB_19,

ATTRIBUTE_CHAR20 CUST_PGM_MAN_ADJ_ATTRIB_20,

ATTRIBUTE_NUMBER1 CUST_PGM_MAN_ADJ_ATB_N1,

ATTRIBUTE_NUMBER2 CUST_PGM_MAN_ADJ_ATB_N2,

ATTRIBUTE_NUMBER3 CUST_PGM_MAN_ADJ_ATB_N3,

ATTRIBUTE_NUMBER4 CUST_PGM_MAN_ADJ_ATB_N4,

ATTRIBUTE_NUMBER5 CUST_PGM_MAN_ADJ_ATB_N5,

ATTRIBUTE_NUMBER6 CUST_PGM_MAN_ADJ_ATB_N6,

ATTRIBUTE_NUMBER7 CUST_PGM_MAN_ADJ_ATB_N7,

ATTRIBUTE_NUMBER8 CUST_PGM_MAN_ADJ_ATB_N8,

ATTRIBUTE_NUMBER9 CUST_PGM_MAN_ADJ_ATB_N9,

ATTRIBUTE_NUMBER10 CUST_PGM_MAN_ADJ_ATB_N10

FROM CJM_CUST_ADJUSTMENTS_ALL_B