VIEW: BOM.CST_RECONCILIATION_SUMMARY#

Source

View Text - Preformatted

select PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID, PO_BALANCE PO_BALANCE, AP_BALANCE AP_BALANCE, WRITE_OFF_BALANCE WRITE_OFF_BALANCE, LAST_RECEIPT_DATE LAST_RECEIPT_DATE, LAST_INVOICE_DIST_DATE LAST_INVOICE_DIST_DATE, LAST_WRITE_OFF_DATE LAST_WRITE_OFF_DATE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, VENDOR_ID VENDOR_ID, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, WRITE_OFF_SELECT_FLAG WRITE_OFF_SELECT_FLAG, OPERATING_UNIT_ID OPERATING_UNIT_ID, BUILD_ID BUILD_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "BOM"."CST_RECONCILIATION_SUMMARY"

View Text - HTML Formatted

SELECT PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID
, PO_BALANCE PO_BALANCE
, AP_BALANCE AP_BALANCE
, WRITE_OFF_BALANCE WRITE_OFF_BALANCE
, LAST_RECEIPT_DATE LAST_RECEIPT_DATE
, LAST_INVOICE_DIST_DATE LAST_INVOICE_DIST_DATE
, LAST_WRITE_OFF_DATE LAST_WRITE_OFF_DATE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, VENDOR_ID VENDOR_ID
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, WRITE_OFF_SELECT_FLAG WRITE_OFF_SELECT_FLAG
, OPERATING_UNIT_ID OPERATING_UNIT_ID
, BUILD_ID BUILD_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "BOM"."CST_RECONCILIATION_SUMMARY"