VIEW: BOM.CST_PAC_ACCRUAL_WRITE_OFFS#

Source

View Text - Preformatted

select TRANSACTION_DATE TRANSACTION_DATE, 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, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, PO_UNIT_OF_MEASURE PO_UNIT_OF_MEASURE, PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, NET_PO_LINE_QUANTITY NET_PO_LINE_QUANTITY, PO_HEADER_ID PO_HEADER_ID, PO_NUM PO_NUM, PO_LINE_NUM PO_LINE_NUM, PO_LINE_ID PO_LINE_ID, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, VENDOR_ID VENDOR_ID, VENDOR_NAME VENDOR_NAME, TRANSACTION_UNIT_PRICE TRANSACTION_UNIT_PRICE, INVOICE_ID INVOICE_ID, INVOICE_LINE_NUM INVOICE_LINE_NUM, AVG_RECEIPT_PRICE AVG_RECEIPT_PRICE, TRANSACTION_AMOUNT TRANSACTION_AMOUNT, LINE_MATCH_ORDER LINE_MATCH_ORDER, TRANSACTION_SOURCE_CODE TRANSACTION_SOURCE_CODE, REASON_ID REASON_ID, COMMENTS COMMENTS, WRITE_OFF_CODE WRITE_OFF_CODE, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, INVOICE_PRICE_VARIANCE INVOICE_PRICE_VARIANCE, PERIOD_ID PERIOD_ID, WRITE_OFF_ID WRITE_OFF_ID, 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, PERIOD_NAME PERIOD_NAME, WRITE_OFF_GL_DATE WRITE_OFF_GL_DATE, TRANSACTION_ORGANIZATION_ID TRANSACTION_ORGANIZATION_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, 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_WRITE_OFFS"

View Text - HTML Formatted

SELECT TRANSACTION_DATE TRANSACTION_DATE
, 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
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PO_UNIT_OF_MEASURE PO_UNIT_OF_MEASURE
, PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, NET_PO_LINE_QUANTITY NET_PO_LINE_QUANTITY
, PO_HEADER_ID PO_HEADER_ID
, PO_NUM PO_NUM
, PO_LINE_NUM PO_LINE_NUM
, PO_LINE_ID PO_LINE_ID
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, VENDOR_ID VENDOR_ID
, VENDOR_NAME VENDOR_NAME
, TRANSACTION_UNIT_PRICE TRANSACTION_UNIT_PRICE
, INVOICE_ID INVOICE_ID
, INVOICE_LINE_NUM INVOICE_LINE_NUM
, AVG_RECEIPT_PRICE AVG_RECEIPT_PRICE
, TRANSACTION_AMOUNT TRANSACTION_AMOUNT
, LINE_MATCH_ORDER LINE_MATCH_ORDER
, TRANSACTION_SOURCE_CODE TRANSACTION_SOURCE_CODE
, REASON_ID REASON_ID
, COMMENTS COMMENTS
, WRITE_OFF_CODE WRITE_OFF_CODE
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, INVOICE_PRICE_VARIANCE INVOICE_PRICE_VARIANCE
, PERIOD_ID PERIOD_ID
, WRITE_OFF_ID WRITE_OFF_ID
, 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
, PERIOD_NAME PERIOD_NAME
, WRITE_OFF_GL_DATE WRITE_OFF_GL_DATE
, TRANSACTION_ORGANIZATION_ID TRANSACTION_ORGANIZATION_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
, 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_WRITE_OFFS"