VIEW: BOM.CST_PAC_ACCRUAL_RECONCILE_TEM#

Source

View Text - Preformatted

select TRANSACTION_DATE TRANSACTION_DATE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, PO_HEADER_ID PO_HEADER_ID, PO_LINE_NUM PO_LINE_NUM, PO_LINE_ID PO_LINE_ID, VENDOR_NAME VENDOR_NAME, INVOICE_ID INVOICE_ID, INVOICE_LINE_NUM INVOICE_LINE_NUM, LINE_MATCH_ORDER LINE_MATCH_ORDER, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, TRANSACTION_ORGANIZATION_ID TRANSACTION_ORGANIZATION_ID, VENDOR_ID VENDOR_ID, ITEM_MASTER_ORGANIZATION_ID ITEM_MASTER_ORGANIZATION_ID, ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID, ACCRUAL_CODE ACCRUAL_CODE, PO_TRANSACTION_TYPE PO_TRANSACTION_TYPE, INVOICE_NUM INVOICE_NUM, RECEIPT_NUM RECEIPT_NUM, PO_TRANSACTION_ID PO_TRANSACTION_ID, INV_TRANSACTION_ID INV_TRANSACTION_ID, INV_TRANSACTION_TYPE_ID INV_TRANSACTION_TYPE_ID, WIP_TRANSACTION_ID WIP_TRANSACTION_ID, WIP_TRANSACTION_TYPE_ID WIP_TRANSACTION_TYPE_ID, PO_UNIT_OF_MEASURE PO_UNIT_OF_MEASURE, PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE, NET_PO_LINE_QUANTITY NET_PO_LINE_QUANTITY, PO_NUM PO_NUM, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, TRANSACTION_UNIT_PRICE TRANSACTION_UNIT_PRICE, AVG_RECEIPT_PRICE AVG_RECEIPT_PRICE, TRANSACTION_AMOUNT TRANSACTION_AMOUNT, TRANSACTION_SOURCE_CODE TRANSACTION_SOURCE_CODE, WRITE_OFF_FLAG WRITE_OFF_FLAG, WRITE_OFF_ID WRITE_OFF_ID, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, REASON_ID REASON_ID, COMMENTS COMMENTS, PERIOD_NAME PERIOD_NAME, NET_PO_LINE_AMOUNT NET_PO_LINE_AMOUNT, INVOICE_PRICE_VARIANCE INVOICE_PRICE_VARIANCE, AGING_DATE AGING_DATE, PERIOD_ID PERIOD_ID, LINE_LOCATION_ID LINE_LOCATION_ID, VENDOR_NAME_ALT VENDOR_NAME_ALT, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, COST_GROUP_ID COST_GROUP_ID, COST_TYPE_ID COST_TYPE_ID, ADJUSTMENT_TRANSACTION ADJUSTMENT_TRANSACTION from "BOM"."CST_PAC_ACCRUAL_RECONCILE_TEMP"

View Text - HTML Formatted

SELECT TRANSACTION_DATE TRANSACTION_DATE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, PO_HEADER_ID PO_HEADER_ID
, PO_LINE_NUM PO_LINE_NUM
, PO_LINE_ID PO_LINE_ID
, VENDOR_NAME VENDOR_NAME
, INVOICE_ID INVOICE_ID
, INVOICE_LINE_NUM INVOICE_LINE_NUM
, LINE_MATCH_ORDER LINE_MATCH_ORDER
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TRANSACTION_ORGANIZATION_ID TRANSACTION_ORGANIZATION_ID
, VENDOR_ID VENDOR_ID
, ITEM_MASTER_ORGANIZATION_ID ITEM_MASTER_ORGANIZATION_ID
, ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID
, ACCRUAL_CODE ACCRUAL_CODE
, PO_TRANSACTION_TYPE PO_TRANSACTION_TYPE
, INVOICE_NUM INVOICE_NUM
, RECEIPT_NUM RECEIPT_NUM
, PO_TRANSACTION_ID PO_TRANSACTION_ID
, INV_TRANSACTION_ID INV_TRANSACTION_ID
, INV_TRANSACTION_TYPE_ID INV_TRANSACTION_TYPE_ID
, WIP_TRANSACTION_ID WIP_TRANSACTION_ID
, WIP_TRANSACTION_TYPE_ID WIP_TRANSACTION_TYPE_ID
, PO_UNIT_OF_MEASURE PO_UNIT_OF_MEASURE
, PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE
, NET_PO_LINE_QUANTITY NET_PO_LINE_QUANTITY
, PO_NUM PO_NUM
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, TRANSACTION_UNIT_PRICE TRANSACTION_UNIT_PRICE
, AVG_RECEIPT_PRICE AVG_RECEIPT_PRICE
, TRANSACTION_AMOUNT TRANSACTION_AMOUNT
, TRANSACTION_SOURCE_CODE TRANSACTION_SOURCE_CODE
, WRITE_OFF_FLAG WRITE_OFF_FLAG
, WRITE_OFF_ID WRITE_OFF_ID
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, REASON_ID REASON_ID
, COMMENTS COMMENTS
, PERIOD_NAME PERIOD_NAME
, NET_PO_LINE_AMOUNT NET_PO_LINE_AMOUNT
, INVOICE_PRICE_VARIANCE INVOICE_PRICE_VARIANCE
, AGING_DATE AGING_DATE
, PERIOD_ID PERIOD_ID
, LINE_LOCATION_ID LINE_LOCATION_ID
, VENDOR_NAME_ALT VENDOR_NAME_ALT
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, COST_GROUP_ID COST_GROUP_ID
, COST_TYPE_ID COST_TYPE_ID
, ADJUSTMENT_TRANSACTION ADJUSTMENT_TRANSACTION
FROM "BOM"."CST_PAC_ACCRUAL_RECONCILE_TEMP"