[Home] [Help]
View: XLA_AP_ENC_GL_PAY_V
View Text
SELECT JE_HEADER_ID JE_HEADER_ID
,
JE_LINE_NUM JE_LINE_NUM
,
ACCOUNTED_CR ACCOUNTED_CR
,
ACCOUNTED_DR ACCOUNTED_DR
,
ACCOUNTING_DATE ACCOUNTING_DATE
,
ACCT_LINE_TYPE ACCT_LINE_TYPE
,
ACCT_LINE_TYPE_NAME ACCT_LINE_TYPE_NAME
,
AEH_ID AEH_ID
,
AEL_ID AEL_ID
,
AEL_TABLE AEL_TABLE
,
AE_LINE_REFERENCE AE_LINE_REFERENCE
,
AE_LINE_REFERENCE AE_LINE_REFERENCE_INTERNAL
,
APPLICATION_ID APPLICATION_ID
,
CODE_COMBINATION_ID CODE_COMBINATION_ID
,
COMMENTS COMMENTS
,
CURRENCY_CODE 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
,
DOC_SEQUENCE_ID DOC_SEQUENCE_ID
,
DOC_SEQUENCE_NAME DOC_SEQUENCE_NAME
,
DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
,
ENTERED_CR ENTERED_CR
,
ENTERED_DR ENTERED_DR
,
GL_TRANSFER_STATUS GL_TRANSFER_STATUS
,
GL_TRANSFER_STATUS_NAME GL_TRANSFER_STATUS_NAME
,
TRANSFER_STATUS_DETAIL_NAME TRANSFER_STATUS_DETAIL_NAME
,
NULL TRANSFER_SYSTEM_NAME
,
NULL TRANSFER_SYSTEM
,
NULL GL_TRANSFER_FROM_TO_NAME
,
NULL ACCOUNTING_COMPLETE
,
NULL ACCOUNTING_COMPLETE_NAME
,
ORG_ID ORG_ID
,
SET_OF_BOOKS_ID SET_OF_BOOKS_ID
,
SOURCE_ID SOURCE_ID
,
SOURCE_TABLE 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
,
TAX_CODE TAX_CODE
,
THIRD_PARTY_ID THIRD_PARTY_ID
,
THIRD_PARTY_NAME THIRD_PARTY_NAME
,
THIRD_PARTY_NUMBER THIRD_PARTY_NUMBER
,
THIRD_PARTY_SUB_ID THIRD_PARTY_SUB_ID
,
THIRD_PARTY_SUB_NAME THIRD_PARTY_SUB_NAME
,
THIRD_PARTY_TYPE THIRD_PARTY_TYPE
,
TRX_CLASS TRX_CLASS
,
TRX_CLASS_NAME TRX_CLASS_NAME
,
TRX_DATE TRX_DATE
,
TRX_HDR_ID TRX_HDR_ID
,
TRX_HDR_TABLE TRX_HDR_TABLE
,
TO_NUMBER(NULL) TRX_NUMBER_C
,
TRX_NUMBER_DISPLAYED TRX_NUMBER_DISPLAYED
,
TO_NUMBER(NULL) TRX_NUMBER_N
,
TRX_TYPE_C TRX_TYPE_C
,
TO_NUMBER(NULL) TRX_TYPE_N
,
TRX_TYPE_NAME 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
,
REQUEST_ID REQUEST_ID
,
PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
,
PROGRAM_ID PROGRAM_ID
,
PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
,
NULL ACCOUNTING_RULE_NAME
,
TO_NUMBER(NULL) INVENTORY_ITEM_ID
,
NULL SALESREP_NAME
,
NULL SALES_ORDER_NUMBER
,
NULL TAX_EXEMPT_NUMBER
,
TO_NUMBER(NULL) TAX_RATE
,
TO_NUMBER(NULL) TRX_DETAIL_LINE_NUMBER
,
TRX_LINE_NUMBER TRX_LINE_NUMBER
,
TRX_LINE_TYPE TRX_LINE_TYPE
,
TRX_LINE_TYPE_NAME TRX_LINE_TYPE_NAME
,
TO_NUMBER(NULL) TRX_QUANTITY
,
TO_NUMBER(NULL ) TRX_SOURCE_ID
,
NULL TRX_SOURCE_NAME
,
NULL 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
,
APPLIED_TO_TRX_HDR_NUMBER_DISP
,
NULL APPLIED_TO_TRX_HDR_NUMBER_C
,
TO_DATE(NULL) APPLIED_TO_TRX_HDR_DATE
,
TO_DATE(NULL) PAYMENT_DEPOSIT_DATE
,
TRX_HDR_CURRENCY TRX_HDR_CURRENCY
,
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
,
ACCOUNTING_EVENT_NUMBER ACCOUNTING_EVENT_NUMBER
,
ACCOUNTING_EVENT_TYPE ACCOUNTING_EVENT_TYPE
,
ACCOUNTING_EVENT_TYPE_NAME ACCOUNTING_EVENT_TYPE_NAME
,
ACCOUNTING_LINE_NUMBER 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
,
TO_DATE(NULL) PAYMENT_CLEARED_DATE
,
USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
,
JE_CATEGORY JE_CATEGORY
,
AEH_ACCOUNTING_ERROR_NAME AEH_ACCOUNTING_ERROR_NAME
,
AEH_ACCOUNTING_ERROR_CODE AEH_ACCOUNTING_ERROR_CODE
,
AEL_ACCOUNTING_ERROR_NAME AEL_ACCOUNTING_ERROR_NAME
,
AEL_ACCOUNTING_ERROR_CODE 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
,
NULL INVENTORY_ORGANIZATION_CODE
,
TO_NUMBER(NULL) 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
,
TO_NUMBER(NULL) WIP_JOB_ID
,
NULL 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
,
TO_NUMBER(NULL) PO_LINE_NUM
,
PO_ORDER_NUMBER PO_ORDER_NUMBER
,
PO_ORDER_RELEASE_NUM PO_ORDER_RELEASE_NUM
,
NULL PO_ORDER_TYPE
,
RCV_RECEIPT_NUM RCV_RECEIPT_NUM
,
TO_NUMBER(NULL) RCV_SHIPMENT_HEADER_ID
,
TO_NUMBER(NULL) UNIT_PRICE
,
TO_NUMBER(NULL) PRICE_OVERRIDE
,
TO_NUMBER(NULL) PO_ORDER_SHIPMENT_NUM
,
TO_NUMBER(NULL) PO_ORDER_DISTRIBUTION_NUM
FROM AP_ENC_GL_PAY_V