eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.XLA_AP_ENC_GL_PAY_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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