VIEW: APPS.JAI_PO_OSPM_AEL_GL_V

Source

View Text - Preformatted

SELECT JE_Header_Id JE_HEADER_ID, JE_Line_Num JE_LINE_NUM, Account_Credit ACCOUNTED_CR, Account_Debit ACCOUNTED_DR, Accounting_Date ACCOUNTING_DATE, NULL ACCT_LINE_TYPE, NULL ACCT_LINE_TYPE_NAME, TO_NUMBER(NULL) AEH_ID, TO_NUMBER(NULL) AEL_ID, NULL AEL_TABLE, NULL AE_LINE_REFERENCE, NULL AE_LINE_REFERENCE_INTERNAL, Application_Id APPLICATION_ID, Account_Id CODE_COMBINATION_ID, NULL COMMENTS, Entered_Currency CURRENCY_CODE, Currency_Conversion_Date CURRENCY_CONVERSION_DATE, Currency_Conversion_Rate CURRENCY_CONVERSION_RATE, Currency_Conversion_Type CURRENCY_CONVERSION_TYPE, Currency_User_Conversion_Type CURRENCY_USER_CONVERSION_TYPE, TO_NUMBER(NULL) DOC_SEQUENCE_ID, NULL DOC_SEQUENCE_NAME, TO_NUMBER(NULL) DOC_SEQUENCE_VALUE, Entered_Credit ENTERED_CR, Entered_Debit ENTERED_DR, NULL GL_TRANSFER_STATUS, NULL GL_TRANSFER_STATUS_NAME, null TRANSFER_STATUS_DETAIL_NAME, null TRANSFER_SYSTEM_NAME, null TRANSFER_SYSTEM, null GL_TRANSFER_FROM_TO_NAME, null ACCOUNTING_COMPLETE, null ACCOUNTING_COMPLETE_NAME, TO_NUMBER(NULL) ORG_ID, Set_of_book_Id SET_OF_BOOKS_ID, TO_NUMBER(NULL) SOURCE_ID, NULL SOURCE_TABLE, TO_NUMBER(NULL) TAXABLE_ENTERED_DR, TO_NUMBER(NULL) TAXABLE_ENTERED_CR, TO_NUMBER(NULL) TAXABLE_ACCOUNTED_DR, TO_NUMBER(NULL) TAXABLE_ACCOUNTED_CR, NULL TAX_CODE, Supplier_Id THIRD_PARTY_ID, Supplier_Name THIRD_PARTY_NAME, Supplier_Number THIRD_PARTY_NUMBER, Supplier_Site_Id THIRD_PARTY_SUB_ID, Supplier_Site THIRD_PARTY_SUB_NAME, NULL THIRD_PARTY_TYPE, Trx_Class TRX_CLASS, Trx_Class_Name TRX_CLASS_NAME, Form_Date TRX_DATE, Trx_Hdr_Id TRX_HDR_ID, Trx_Hdr_Table TRX_HDR_TABLE, NULL TRX_NUMBER_C, NULL TRX_NUMBER_DISPLAYED, TO_NUMBER(NULL) TRX_NUMBER_N, Event_Type TRX_TYPE_C, TO_NUMBER(NULL) TRX_TYPE_N, NULL TRX_TYPE_NAME, Last_Update_Date LAST_UPDATE_DATE, Last_Updated_By LAST_UPDATED_BY, Creation_Date CREATION_DATE, Created_By CREATED_BY, Last_Update_Login LAST_UPDATE_LOGIN, TO_NUMBER(NULL) REQUEST_ID, TO_NUMBER(NULL) PROGRAM_APPLICATION_ID, TO_NUMBER(NULL) PROGRAM_ID, TO_DATE(NULL) PROGRAM_UPDATE_DATE, NULL ACCOUNTING_RULE_NAME, Item_id INVENTORY_ITEM_ID, NULL SALESREP_NAME, NULL SALES_ORDER_NUMBER, NULL TAX_EXEMPT_NUMBER, TO_NUMBER(NULL) TAX_RATE, Primary_Form_Number TRX_DETAIL_LINE_NUMBER, Form_Number TRX_LINE_NUMBER, NULL TRX_LINE_TYPE, NULL TRX_LINE_TYPE_NAME, Original_Quantity TRX_QUANTITY, TO_NUMBER(NULL) TRX_SOURCE_ID, NULL TRX_SOURCE_NAME, UOM TRX_UOM, TO_NUMBER(NULL) UNIT_SELLING_PRICE, NULL AR_ADJUSTMENT_CREATION_TYPE, NULL AR_ADJUSTMENT_TYPE, NULL PAYMENT_NUMBER, TO_DATE(NULL) PAYMENT_DATE, NULL CHARGEBACK_NUMBER, NULL APPLIED_TO_TRX_HDR_TABLE, TO_NUMBER(NULL) APPLIED_TO_TRX_HDR_ID, NULL APPLIED_TO_TRX_HDR_NUMBER_DISP, NULL APPLIED_TO_TRX_HDR_NUMBER_C, TO_DATE(NULL) APPLIED_TO_TRX_HDR_DATE, Dispatch_Date PAYMENT_DEPOSIT_DATE, NULL TRX_HDR_CURRENCY, NULL BANK_ACCOUNT_NAME, NULL REVERSAL_COMMENTS, TO_DATE(NULL) REVERSAL_DATE, TO_DATE(NULL) APPLICATION_DATE, NULL APPLIED_TO_TRX_HDR_CURRENCY, NULL APPLIED_TO_TRX_LINE_TYPE_NAME, NULL APPLIED_TO_TRX_LINE_TYPE, TO_NUMBER(NULL) APPLIED_TO_TRX_LINE_NUMBER, NULL AR_ACTIVITY_NAME, NULL DISTRIBUTION_SET_NAME, TO_NUMBER(NULL) ACCOUNTING_EVENT_NUMBER, NULL ACCOUNTING_EVENT_TYPE, NULL ACCOUNTING_EVENT_TYPE_NAME, TO_NUMBER(NULL) ACCOUNTING_LINE_NUMBER, TO_NUMBER(NULL) BANK_STATEMENT_DOC_SEQ_ID, NULL BANK_STATEMENT_DOC_SEQ_NAME, TO_NUMBER(NULL) BANK_STATEMENT_DOC_SEQ_VALUE, TO_NUMBER(NULL) BANK_STATEMENT_LINE_NUMBER, NULL BANK_STATEMENT_NUMBER, NULL PAYMENT_RECON_CURRENCY, Receive_Upto PAYMENT_CLEARED_DATE, User_Je_Source_Name USER_JE_SOURCE_NAME, Je_Source JE_SOURCE, User_Je_Category_Name USER_JE_CATEGORY_NAME, Je_Category JE_CATEGORY, null AEH_ACCOUNTING_ERROR_NAME, null AEH_ACCOUNTING_ERROR_CODE, null AEL_ACCOUNTING_ERROR_NAME, null AEL_ACCOUNTING_ERROR_CODE, TO_DATE(NULL) PA_ACCRUE_THRU_DATE, NULL PA_AGREEMENT_NUM, NULL PA_CUSTOMER_NAME, TO_NUMBER(NULL) PA_CUSTOMER_NUMBER, TO_NUMBER(NULL) PA_DRI_NUMBER, NULL PA_EI_EV_ORG, NULL PA_EI_EV_TYPE, NULL PA_EMPLOYEE_NAME, NULL PA_EMPLOYEE_NUM, TO_NUMBER(NULL) PA_EVENT_NUM, TO_DATE(NULL) PA_GL_TRANSFER_DATE, TO_NUMBER(NULL) PA_LINE_NUMBER, NULL PA_NL_RESOURCE, NULL PA_NL_RESOURCE_ORG, TO_DATE(NULL) PA_PERIOD_DATE, TO_NUMBER(NULL) PA_PROJECT_ID, NULL PA_PROJECT_NAME, NULL PA_PROJECT_NUM, TO_NUMBER(NULL) PA_QUANTITY, NULL PA_SUPPLIER_NAME, NULL PA_SUPPLIER_NUM, NULL PA_TASK_NAME, NULL PA_TASK_NUM, NULL PA_TRANSFER_TO_GL, TO_NUMBER(NULL) PA_TRANS_ID, NULL PA_UOM, NULL PA_VIEW_LABOR_COST, NULL PRVDR_ORGANIZATION_NAME, NULL RECVR_ORGANIZATION_NAME, NULL PRVDR_OU_NAME, NULL RECVR_OU_NAME, NULL CC_TYPE_NAME, NULL CC_TYPE, NULL CC_PROC_METHOD_NAME, NULL CC_PROC_METHOD, TO_NUMBER(NULL) ASSET_ID, NULL ASSET_NUMBER, NULL ASSET_DESCRIPTION, NULL ASSET_BOOK_TYPE_CODE, TO_NUMBER(NULL) ASSET_CATEGORY_FLEX_STRUCTURE, TO_NUMBER(NULL) ASSET_CATEGORY_ID, TO_NUMBER(NULL) ASSET_KEY_FLEX_STRUCTURE, TO_NUMBER(NULL) ASSET_KEY_CCID, TO_NUMBER(NULL) COST_ELEMENT_ID, NULL COST_ELEMENT_NAME, TO_NUMBER(NULL) GL_BATCH_ID, TO_NUMBER(NULL) INVENTORY_ITEM_LOCATOR_ID, NULL INVENTORY_ITEM_LOCATOR_NAME, NULL INVENTORY_ITEM_REVISION, null ITEM_DESCRIPTION, Inv_Org_Code INVENTORY_ORGANIZATION_CODE, Inv_Org_Id INVENTORY_ORGANIZATION_ID, TO_NUMBER(NULL) MFG_OPERATION_SEQ_NUM, NULL SUBINVENTORY, NULL TRX_REASON_NAME, TO_NUMBER(NULL) TRX_SOURCE_TYPE_ID, NULL TRX_SOURCE_TYPE_NAME, NULL UNIT_COST, TO_NUMBER(NULL) COST_TYPE_ID, NULL COST_TYPE_NAME, NULL BOM_DEPARTMENT_CODE, NULL BOM_DEPARTMENT_NAME, NULL WIP_ASSEMBLY, NULL WIP_BASIS, NULL WIP_FLOW_SCHEDULE_NUMBER, Job_Id WIP_JOB_ID, Job_Name WIP_JOB_NAME, NULL WIP_LINE_CODE, TO_NUMBER(NULL) WIP_LINE_ID, TO_NUMBER(NULL) WIP_RESOURCE_ID, NULL WIP_RESOURCE_NAME, TO_NUMBER(NULL) WIP_RESOURCE_SEQ_NUM, Dispatched_Quantity PO_LINE_NUM, Po_Number PO_ORDER_NUMBER, Dispatch_Entry_Number PO_ORDER_RELEASE_NUM, Dispatch_Register PO_ORDER_TYPE, Receipt_Register RCV_RECEIPT_NUM, Receipt_Entry_Number RCV_SHIPMENT_HEADER_ID, TO_NUMBER(NULL) UNIT_PRICE, TO_NUMBER(NULL) PRICE_OVERRIDE, Return_Quantity PO_ORDER_SHIPMENT_NUM, TO_NUMBER(NULL) PO_ORDER_DISTRIBUTION_NUM FROM JAI_PO_OSPM_AEL_V

View Text - HTML Formatted

SELECT JE_HEADER_ID JE_HEADER_ID
, JE_LINE_NUM JE_LINE_NUM
, ACCOUNT_CREDIT ACCOUNTED_CR
, ACCOUNT_DEBIT ACCOUNTED_DR
, ACCOUNTING_DATE ACCOUNTING_DATE
, NULL ACCT_LINE_TYPE
, NULL ACCT_LINE_TYPE_NAME
, TO_NUMBER(NULL) AEH_ID
, TO_NUMBER(NULL) AEL_ID
, NULL AEL_TABLE
, NULL AE_LINE_REFERENCE
, NULL AE_LINE_REFERENCE_INTERNAL
, APPLICATION_ID APPLICATION_ID
, ACCOUNT_ID CODE_COMBINATION_ID
, NULL COMMENTS
, ENTERED_CURRENCY CURRENCY_CODE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, TO_NUMBER(NULL) DOC_SEQUENCE_ID
, NULL DOC_SEQUENCE_NAME
, TO_NUMBER(NULL) DOC_SEQUENCE_VALUE
, ENTERED_CREDIT ENTERED_CR
, ENTERED_DEBIT ENTERED_DR
, NULL GL_TRANSFER_STATUS
, NULL GL_TRANSFER_STATUS_NAME
, NULL TRANSFER_STATUS_DETAIL_NAME
, NULL TRANSFER_SYSTEM_NAME
, NULL TRANSFER_SYSTEM
, NULL GL_TRANSFER_FROM_TO_NAME
, NULL ACCOUNTING_COMPLETE
, NULL ACCOUNTING_COMPLETE_NAME
, TO_NUMBER(NULL) ORG_ID
, SET_OF_BOOK_ID SET_OF_BOOKS_ID
, TO_NUMBER(NULL) SOURCE_ID
, NULL SOURCE_TABLE
, TO_NUMBER(NULL) TAXABLE_ENTERED_DR
, TO_NUMBER(NULL) TAXABLE_ENTERED_CR
, TO_NUMBER(NULL) TAXABLE_ACCOUNTED_DR
, TO_NUMBER(NULL) TAXABLE_ACCOUNTED_CR
, NULL TAX_CODE
, SUPPLIER_ID THIRD_PARTY_ID
, SUPPLIER_NAME THIRD_PARTY_NAME
, SUPPLIER_NUMBER THIRD_PARTY_NUMBER
, SUPPLIER_SITE_ID THIRD_PARTY_SUB_ID
, SUPPLIER_SITE THIRD_PARTY_SUB_NAME
, NULL THIRD_PARTY_TYPE
, TRX_CLASS TRX_CLASS
, TRX_CLASS_NAME TRX_CLASS_NAME
, FORM_DATE TRX_DATE
, TRX_HDR_ID TRX_HDR_ID
, TRX_HDR_TABLE TRX_HDR_TABLE
, NULL TRX_NUMBER_C
, NULL TRX_NUMBER_DISPLAYED
, TO_NUMBER(NULL) TRX_NUMBER_N
, EVENT_TYPE TRX_TYPE_C
, TO_NUMBER(NULL) TRX_TYPE_N
, NULL TRX_TYPE_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TO_NUMBER(NULL) REQUEST_ID
, TO_NUMBER(NULL) PROGRAM_APPLICATION_ID
, TO_NUMBER(NULL) PROGRAM_ID
, TO_DATE(NULL) PROGRAM_UPDATE_DATE
, NULL ACCOUNTING_RULE_NAME
, ITEM_ID INVENTORY_ITEM_ID
, NULL SALESREP_NAME
, NULL SALES_ORDER_NUMBER
, NULL TAX_EXEMPT_NUMBER
, TO_NUMBER(NULL) TAX_RATE
, PRIMARY_FORM_NUMBER TRX_DETAIL_LINE_NUMBER
, FORM_NUMBER TRX_LINE_NUMBER
, NULL TRX_LINE_TYPE
, NULL TRX_LINE_TYPE_NAME
, ORIGINAL_QUANTITY TRX_QUANTITY
, TO_NUMBER(NULL) TRX_SOURCE_ID
, NULL TRX_SOURCE_NAME
, UOM TRX_UOM
, TO_NUMBER(NULL) UNIT_SELLING_PRICE
, NULL AR_ADJUSTMENT_CREATION_TYPE
, NULL AR_ADJUSTMENT_TYPE
, NULL PAYMENT_NUMBER
, TO_DATE(NULL) PAYMENT_DATE
, NULL CHARGEBACK_NUMBER
, NULL APPLIED_TO_TRX_HDR_TABLE
, TO_NUMBER(NULL) APPLIED_TO_TRX_HDR_ID
, NULL APPLIED_TO_TRX_HDR_NUMBER_DISP
, NULL APPLIED_TO_TRX_HDR_NUMBER_C
, TO_DATE(NULL) APPLIED_TO_TRX_HDR_DATE
, DISPATCH_DATE PAYMENT_DEPOSIT_DATE
, NULL TRX_HDR_CURRENCY
, NULL BANK_ACCOUNT_NAME
, NULL REVERSAL_COMMENTS
, TO_DATE(NULL) REVERSAL_DATE
, TO_DATE(NULL) APPLICATION_DATE
, NULL APPLIED_TO_TRX_HDR_CURRENCY
, NULL APPLIED_TO_TRX_LINE_TYPE_NAME
, NULL APPLIED_TO_TRX_LINE_TYPE
, TO_NUMBER(NULL) APPLIED_TO_TRX_LINE_NUMBER
, NULL AR_ACTIVITY_NAME
, NULL DISTRIBUTION_SET_NAME
, TO_NUMBER(NULL) ACCOUNTING_EVENT_NUMBER
, NULL ACCOUNTING_EVENT_TYPE
, NULL ACCOUNTING_EVENT_TYPE_NAME
, TO_NUMBER(NULL) ACCOUNTING_LINE_NUMBER
, TO_NUMBER(NULL) BANK_STATEMENT_DOC_SEQ_ID
, NULL BANK_STATEMENT_DOC_SEQ_NAME
, TO_NUMBER(NULL) BANK_STATEMENT_DOC_SEQ_VALUE
, TO_NUMBER(NULL) BANK_STATEMENT_LINE_NUMBER
, NULL BANK_STATEMENT_NUMBER
, NULL PAYMENT_RECON_CURRENCY
, RECEIVE_UPTO PAYMENT_CLEARED_DATE
, USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME
, JE_SOURCE JE_SOURCE
, USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, JE_CATEGORY JE_CATEGORY
, NULL AEH_ACCOUNTING_ERROR_NAME
, NULL AEH_ACCOUNTING_ERROR_CODE
, NULL AEL_ACCOUNTING_ERROR_NAME
, NULL AEL_ACCOUNTING_ERROR_CODE
, TO_DATE(NULL) PA_ACCRUE_THRU_DATE
, NULL PA_AGREEMENT_NUM
, NULL PA_CUSTOMER_NAME
, TO_NUMBER(NULL) PA_CUSTOMER_NUMBER
, TO_NUMBER(NULL) PA_DRI_NUMBER
, NULL PA_EI_EV_ORG
, NULL PA_EI_EV_TYPE
, NULL PA_EMPLOYEE_NAME
, NULL PA_EMPLOYEE_NUM
, TO_NUMBER(NULL) PA_EVENT_NUM
, TO_DATE(NULL) PA_GL_TRANSFER_DATE
, TO_NUMBER(NULL) PA_LINE_NUMBER
, NULL PA_NL_RESOURCE
, NULL PA_NL_RESOURCE_ORG
, TO_DATE(NULL) PA_PERIOD_DATE
, TO_NUMBER(NULL) PA_PROJECT_ID
, NULL PA_PROJECT_NAME
, NULL PA_PROJECT_NUM
, TO_NUMBER(NULL) PA_QUANTITY
, NULL PA_SUPPLIER_NAME
, NULL PA_SUPPLIER_NUM
, NULL PA_TASK_NAME
, NULL PA_TASK_NUM
, NULL PA_TRANSFER_TO_GL
, TO_NUMBER(NULL) PA_TRANS_ID
, NULL PA_UOM
, NULL PA_VIEW_LABOR_COST
, NULL PRVDR_ORGANIZATION_NAME
, NULL RECVR_ORGANIZATION_NAME
, NULL PRVDR_OU_NAME
, NULL RECVR_OU_NAME
, NULL CC_TYPE_NAME
, NULL CC_TYPE
, NULL CC_PROC_METHOD_NAME
, NULL CC_PROC_METHOD
, TO_NUMBER(NULL) ASSET_ID
, NULL ASSET_NUMBER
, NULL ASSET_DESCRIPTION
, NULL ASSET_BOOK_TYPE_CODE
, TO_NUMBER(NULL) ASSET_CATEGORY_FLEX_STRUCTURE
, TO_NUMBER(NULL) ASSET_CATEGORY_ID
, TO_NUMBER(NULL) ASSET_KEY_FLEX_STRUCTURE
, TO_NUMBER(NULL) ASSET_KEY_CCID
, TO_NUMBER(NULL) COST_ELEMENT_ID
, NULL COST_ELEMENT_NAME
, TO_NUMBER(NULL) GL_BATCH_ID
, TO_NUMBER(NULL) INVENTORY_ITEM_LOCATOR_ID
, NULL INVENTORY_ITEM_LOCATOR_NAME
, NULL INVENTORY_ITEM_REVISION
, NULL ITEM_DESCRIPTION
, INV_ORG_CODE INVENTORY_ORGANIZATION_CODE
, INV_ORG_ID INVENTORY_ORGANIZATION_ID
, TO_NUMBER(NULL) MFG_OPERATION_SEQ_NUM
, NULL SUBINVENTORY
, NULL TRX_REASON_NAME
, TO_NUMBER(NULL) TRX_SOURCE_TYPE_ID
, NULL TRX_SOURCE_TYPE_NAME
, NULL UNIT_COST
, TO_NUMBER(NULL) COST_TYPE_ID
, NULL COST_TYPE_NAME
, NULL BOM_DEPARTMENT_CODE
, NULL BOM_DEPARTMENT_NAME
, NULL WIP_ASSEMBLY
, NULL WIP_BASIS
, NULL WIP_FLOW_SCHEDULE_NUMBER
, JOB_ID WIP_JOB_ID
, JOB_NAME WIP_JOB_NAME
, NULL WIP_LINE_CODE
, TO_NUMBER(NULL) WIP_LINE_ID
, TO_NUMBER(NULL) WIP_RESOURCE_ID
, NULL WIP_RESOURCE_NAME
, TO_NUMBER(NULL) WIP_RESOURCE_SEQ_NUM
, DISPATCHED_QUANTITY PO_LINE_NUM
, PO_NUMBER PO_ORDER_NUMBER
, DISPATCH_ENTRY_NUMBER PO_ORDER_RELEASE_NUM
, DISPATCH_REGISTER PO_ORDER_TYPE
, RECEIPT_REGISTER RCV_RECEIPT_NUM
, RECEIPT_ENTRY_NUMBER RCV_SHIPMENT_HEADER_ID
, TO_NUMBER(NULL) UNIT_PRICE
, TO_NUMBER(NULL) PRICE_OVERRIDE
, RETURN_QUANTITY PO_ORDER_SHIPMENT_NUM
, TO_NUMBER(NULL) PO_ORDER_DISTRIBUTION_NUM
FROM JAI_PO_OSPM_AEL_V