CJM_CUST_ADJUSTMENTS

Details

Schema: FUSION
Object owner: CJM
Object type: VIEW

Columns

Name
MANUAL_ADJUSTMENT_ID MANUAL_ADJUSTMENT_NUMBER OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN BU_ID STATUS_CODE USER_STATUS_ID ADJUSTMENT_TYPE_CODE ADJUSTMENT_TYPE_ID ADJUSTMENT_REASON_ID ENABLE_BENEFICIARY_FLAG BENEFICIARY_TYPE_CODE BENEFICIARY_VALUE_CODE TRX_CUST_ACCOUNT_ID TRX_BILL_TO_SITE_USE_ID PROGRAM_HEADER_ID ADJUSTMENT_AMOUNT ADJUSTMENT_CURRENCY_CODE REQUESTED_GL_DATE ADJUSTMENT_DATE ADJUST_BY_PRODUCT_FLAG INVOICE_NUMBER INVOICE_DATE OWNER_ID SUBMITTED_BY SUBMITTED_DATE APPROVED_DATE ATTRIBUTE_CATEGORY ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR20 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 ADJUSTMENT_COMMENTS REJECTED_DATE

Name

MANUAL_ADJUSTMENT_ID

MANUAL_ADJUSTMENT_NUMBER

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

BU_ID

STATUS_CODE

USER_STATUS_ID

ADJUSTMENT_TYPE_CODE

ADJUSTMENT_TYPE_ID

ADJUSTMENT_REASON_ID

ENABLE_BENEFICIARY_FLAG

BENEFICIARY_TYPE_CODE

BENEFICIARY_VALUE_CODE

TRX_CUST_ACCOUNT_ID

TRX_BILL_TO_SITE_USE_ID

PROGRAM_HEADER_ID

ADJUSTMENT_AMOUNT

ADJUSTMENT_CURRENCY_CODE

REQUESTED_GL_DATE

ADJUSTMENT_DATE

ADJUST_BY_PRODUCT_FLAG

INVOICE_NUMBER

INVOICE_DATE

OWNER_ID

SUBMITTED_BY

SUBMITTED_DATE

APPROVED_DATE

ATTRIBUTE_CATEGORY

ATTRIBUTE_CHAR1

ATTRIBUTE_CHAR2

ATTRIBUTE_CHAR3

ATTRIBUTE_CHAR4

ATTRIBUTE_CHAR5

ATTRIBUTE_CHAR6

ATTRIBUTE_CHAR7

ATTRIBUTE_CHAR8

ATTRIBUTE_CHAR9

ATTRIBUTE_CHAR10

ATTRIBUTE_CHAR11

ATTRIBUTE_CHAR12

ATTRIBUTE_CHAR13

ATTRIBUTE_CHAR14

ATTRIBUTE_CHAR15

ATTRIBUTE_CHAR16

ATTRIBUTE_CHAR17

ATTRIBUTE_CHAR18

ATTRIBUTE_CHAR19

ATTRIBUTE_CHAR20

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

ADJUSTMENT_COMMENTS

REJECTED_DATE

Query

SQL_Statement
SELECT B.MANUAL_ADJUSTMENT_ID, B.MANUAL_ADJUSTMENT_NUMBER, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.BU_ID, B.STATUS_CODE, B.USER_STATUS_ID, B.ADJUSTMENT_TYPE_CODE, B.ADJUSTMENT_TYPE_ID, B.ADJUSTMENT_REASON_ID, B.ENABLE_BENEFICIARY_FLAG, B.BENEFICIARY_TYPE_CODE, B.BENEFICIARY_VALUE_CODE, B.TRX_CUST_ACCOUNT_ID, B.TRX_BILL_TO_SITE_USE_ID, B.PROGRAM_HEADER_ID, B.ADJUSTMENT_AMOUNT, B.ADJUSTMENT_CURRENCY_CODE, B.REQUESTED_GL_DATE, B.ADJUSTMENT_DATE, B.ADJUST_BY_PRODUCT_FLAG, B.INVOICE_NUMBER, B.INVOICE_DATE, B.OWNER_ID, B.SUBMITTED_BY, B.SUBMITTED_DATE, B.APPROVED_DATE, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE_CHAR1, B.ATTRIBUTE_CHAR2, B.ATTRIBUTE_CHAR3, B.ATTRIBUTE_CHAR4, B.ATTRIBUTE_CHAR5, B.ATTRIBUTE_CHAR6, B.ATTRIBUTE_CHAR7, B.ATTRIBUTE_CHAR8, B.ATTRIBUTE_CHAR9, B.ATTRIBUTE_CHAR10, B.ATTRIBUTE_CHAR11, B.ATTRIBUTE_CHAR12, B.ATTRIBUTE_CHAR13, B.ATTRIBUTE_CHAR14, B.ATTRIBUTE_CHAR15, B.ATTRIBUTE_CHAR16, B.ATTRIBUTE_CHAR17, B.ATTRIBUTE_CHAR18, B.ATTRIBUTE_CHAR19, B.ATTRIBUTE_CHAR20, B.ATTRIBUTE_NUMBER1, B.ATTRIBUTE_NUMBER2, B.ATTRIBUTE_NUMBER3, B.ATTRIBUTE_NUMBER4, B.ATTRIBUTE_NUMBER5, B.ATTRIBUTE_NUMBER6, B.ATTRIBUTE_NUMBER7, B.ATTRIBUTE_NUMBER8, B.ATTRIBUTE_NUMBER9, B.ATTRIBUTE_NUMBER10, B.ATTRIBUTE_DATE1, B.ATTRIBUTE_DATE2, B.ATTRIBUTE_DATE3, B.ATTRIBUTE_DATE4, B.ATTRIBUTE_DATE5, B.ATTRIBUTE_TIMESTAMP1, B.ATTRIBUTE_TIMESTAMP2, B.ATTRIBUTE_TIMESTAMP3, B.ATTRIBUTE_TIMESTAMP4, B.ATTRIBUTE_TIMESTAMP5, TL.ADJUSTMENT_COMMENTS, B.REJECTED_DATE FROM CJM_CUST_ADJUSTMENTS_ALL_B B, CJM_CUST_ADJUSTMENTS_ALL_TL TL WHERE B.MANUAL_ADJUSTMENT_ID=TL.MANUAL_ADJUSTMENT_ID AND TL.LANGUAGE=userenv('LANG')

SQL_Statement

SELECT

B.MANUAL_ADJUSTMENT_ID,

B.MANUAL_ADJUSTMENT_NUMBER,

B.OBJECT_VERSION_NUMBER,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.BU_ID,

B.STATUS_CODE,

B.USER_STATUS_ID,

B.ADJUSTMENT_TYPE_CODE,

B.ADJUSTMENT_TYPE_ID,

B.ADJUSTMENT_REASON_ID,

B.ENABLE_BENEFICIARY_FLAG,

B.BENEFICIARY_TYPE_CODE,

B.BENEFICIARY_VALUE_CODE,

B.TRX_CUST_ACCOUNT_ID,

B.TRX_BILL_TO_SITE_USE_ID,

B.PROGRAM_HEADER_ID,

B.ADJUSTMENT_AMOUNT,

B.ADJUSTMENT_CURRENCY_CODE,

B.REQUESTED_GL_DATE,

B.ADJUSTMENT_DATE,

B.ADJUST_BY_PRODUCT_FLAG,

B.INVOICE_NUMBER,

B.INVOICE_DATE,

B.OWNER_ID,

B.SUBMITTED_BY,

B.SUBMITTED_DATE,

B.APPROVED_DATE,

B.ATTRIBUTE_CATEGORY,

B.ATTRIBUTE_CHAR1,

B.ATTRIBUTE_CHAR2,

B.ATTRIBUTE_CHAR3,

B.ATTRIBUTE_CHAR4,

B.ATTRIBUTE_CHAR5,

B.ATTRIBUTE_CHAR6,

B.ATTRIBUTE_CHAR7,

B.ATTRIBUTE_CHAR8,

B.ATTRIBUTE_CHAR9,

B.ATTRIBUTE_CHAR10,

B.ATTRIBUTE_CHAR11,

B.ATTRIBUTE_CHAR12,

B.ATTRIBUTE_CHAR13,

B.ATTRIBUTE_CHAR14,

B.ATTRIBUTE_CHAR15,

B.ATTRIBUTE_CHAR16,

B.ATTRIBUTE_CHAR17,

B.ATTRIBUTE_CHAR18,

B.ATTRIBUTE_CHAR19,

B.ATTRIBUTE_CHAR20,

B.ATTRIBUTE_NUMBER1,

B.ATTRIBUTE_NUMBER2,

B.ATTRIBUTE_NUMBER3,

B.ATTRIBUTE_NUMBER4,

B.ATTRIBUTE_NUMBER5,

B.ATTRIBUTE_NUMBER6,

B.ATTRIBUTE_NUMBER7,

B.ATTRIBUTE_NUMBER8,

B.ATTRIBUTE_NUMBER9,

B.ATTRIBUTE_NUMBER10,

B.ATTRIBUTE_DATE1,

B.ATTRIBUTE_DATE2,

B.ATTRIBUTE_DATE3,

B.ATTRIBUTE_DATE4,

B.ATTRIBUTE_DATE5,

B.ATTRIBUTE_TIMESTAMP1,

B.ATTRIBUTE_TIMESTAMP2,

B.ATTRIBUTE_TIMESTAMP3,

B.ATTRIBUTE_TIMESTAMP4,

B.ATTRIBUTE_TIMESTAMP5,

TL.ADJUSTMENT_COMMENTS,

B.REJECTED_DATE

FROM

CJM_CUST_ADJUSTMENTS_ALL_B B,

CJM_CUST_ADJUSTMENTS_ALL_TL TL

WHERE

B.MANUAL_ADJUSTMENT_ID=TL.MANUAL_ADJUSTMENT_ID

AND TL.LANGUAGE=userenv('LANG')