CJM_MANUAL_ADJUSTMENTS_VL

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 REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE BU_ID STATUS_CODE ACCRUAL_TYPE_CODE ADJUSTMENT_TYPE_CODE ADJUSTMENT_TYPE_ID BENEFICIARY_TYPE_CODE VENDOR_ID VENDOR_SITE_ID PARTY_ID CUST_ACCOUNT_ID BILL_TO_CUSTOMER_ID BILL_TO_SITE_USE_ID SHIP_TO_PARTY_SITE_ID PROGRAM_HEADER_ID PROGRAM_LINE_ID ITEM_LEVEL_CODE ITEM_ID OBJECT_TYPE OBJECT_ID OBJECT_LINE_ID ADJUSTMENT_AMOUNT ADJUSTMENT_CURRENCY_CODE REQUESTED_GL_DATE ADJUSTMENT_DATE INVOICE_DATE INVOICE_ID INVOICE_NUMBER INVOICE_SOURCE_CODE CUSTOMER_TRX_LINE_ID INVOICE_LINE_NUMBER ADJUSTMENT_REASON_ID TP_ITEM_ID INVOICE_SOURCE_APPLICATION RECEIPT_ID RECEIPT_NUMBER EXPECTED_RECEIPT_DATE PO_HEADER_ID PO_NUMBER TRANSACTION_ID PO_DATE TRANSACTION_DATE SOURCE_UTILIZATION_ID INVENTORY_ORGANIZATION_ID OWNER_ID APPROVED_BY APPROVED_DATE BILL_TO_LOCATION_ID SHIP_TO_LOCATION_ID ORIG_SYSTEM_SOURCE DOCUMENT_TYPE_CODE OBJECT_LINE_REASON ORIG_OBJECT_NUMBER ORIG_OBJECT_LINE_NUM EXCHANGE_RATE_TYPE EXCHANGE_RATE_DATE ACCRUAL_REVERSAL_FLAG 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

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.REQUEST_ID, B.JOB_DEFINITION_NAME, B.JOB_DEFINITION_PACKAGE, B.BU_ID, B.STATUS_CODE, B.ACCRUAL_TYPE_CODE, B.ADJUSTMENT_TYPE_CODE, B.ADJUSTMENT_TYPE_ID, B.BENEFICIARY_TYPE_CODE, B.VENDOR_ID, B.VENDOR_SITE_ID, B.PARTY_ID, B.CUST_ACCOUNT_ID, B.BILL_TO_CUSTOMER_ID, B.BILL_TO_SITE_USE_ID, B.SHIP_TO_PARTY_SITE_ID, B.PROGRAM_HEADER_ID, B.PROGRAM_LINE_ID, B.ITEM_LEVEL_CODE, B.ITEM_ID, B.OBJECT_TYPE, B.OBJECT_ID, B.OBJECT_LINE_ID, B.ADJUSTMENT_AMOUNT, B.ADJUSTMENT_CURRENCY_CODE, B.REQUESTED_GL_DATE, B.ADJUSTMENT_DATE, B.INVOICE_DATE, B.INVOICE_ID, B.INVOICE_NUMBER, B.INVOICE_SOURCE_CODE, B.CUSTOMER_TRX_LINE_ID, B.INVOICE_LINE_NUMBER, B.ADJUSTMENT_REASON_ID, B.TP_ITEM_ID, B.INVOICE_SOURCE_APPLICATION, B.RECEIPT_ID, B.RECEIPT_NUMBER, B.EXPECTED_RECEIPT_DATE, B.PO_HEADER_ID, B.PO_NUMBER, B.TRANSACTION_ID, B.PO_DATE, B.TRANSACTION_DATE, B.SOURCE_UTILIZATION_ID, B.INVENTORY_ORGANIZATION_ID, B.OWNER_ID, B.APPROVED_BY, B.APPROVED_DATE, B.BILL_TO_LOCATION_ID, B.SHIP_TO_LOCATION_ID, B.ORIG_SYSTEM_SOURCE, B.DOCUMENT_TYPE_CODE, B.OBJECT_LINE_REASON, B.ORIG_OBJECT_NUMBER, B.ORIG_OBJECT_LINE_NUM, B.EXCHANGE_RATE_TYPE, B.EXCHANGE_RATE_DATE, B.ACCRUAL_REVERSAL_FLAG, 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 FROM CJM_MANUAL_ADJUSTMENTS_ALL_B B, CJM_MANUAL_ADJUSTMENTS_ALL_TL TL WHERE B.MANUAL_ADJUSTMENT_ID = TL.MANUAL_ADJUSTMENT_ID AND TL.LANGUAGE = userenv('LANG')