VIEW: PO.RCV_ACCOUNTING_EVENTS#

Source

View Text - Preformatted

select ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_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_UDPATE_DATE PROGRAM_UDPATE_DATE, RCV_TRANSACTION_ID RCV_TRANSACTION_ID, EVENT_TYPE_ID EVENT_TYPE_ID, EVENT_SOURCE EVENT_SOURCE, EVENT_SOURCE_ID EVENT_SOURCE_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ORG_ID ORG_ID, TRANSFER_ORG_ID TRANSFER_ORG_ID, ORGANIZATION_ID ORGANIZATION_ID, TRANSFER_ORGANIZATION_ID TRANSFER_ORGANIZATION_ID, DEBIT_ACCOUNT_ID DEBIT_ACCOUNT_ID, CREDIT_ACCOUNT_ID CREDIT_ACCOUNT_ID, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, TRANSACTION_UNIT_OF_MEASURE TRANSACTION_UNIT_OF_MEASURE, SOURCE_DOC_QUANTITY SOURCE_DOC_QUANTITY, SOURCE_DOC_UNIT_OF_MEASURE SOURCE_DOC_UNIT_OF_MEASURE, PRIMARY_QUANTITY PRIMARY_QUANTITY, PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, PO_HEADER_ID PO_HEADER_ID, PO_RELEASE_ID PO_RELEASE_ID, PO_LINE_ID PO_LINE_ID, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, INTERCOMPANY_PRICING_OPTION INTERCOMPANY_PRICING_OPTION, UNIT_PRICE UNIT_PRICE, TRANSACTION_AMOUNT TRANSACTION_AMOUNT, PRIOR_UNIT_PRICE PRIOR_UNIT_PRICE, NR_TAX NR_TAX, REC_TAX REC_TAX, NR_TAX_AMOUNT NR_TAX_AMOUNT, REC_TAX_AMOUNT REC_TAX_AMOUNT, PRIOR_NR_TAX PRIOR_NR_TAX, PRIOR_REC_TAX PRIOR_REC_TAX, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, ACCOUNTED_FLAG ACCOUNTED_FLAG, PROCUREMENT_ORG_FLAG PROCUREMENT_ORG_FLAG, CROSS_OU_FLAG CROSS_OU_FLAG, TRX_FLOW_HEADER_ID TRX_FLOW_HEADER_ID, INVOICED_FLAG INVOICED_FLAG, PA_ADDITION_FLAG PA_ADDITION_FLAG, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, GL_GROUP_ID GL_GROUP_ID, QUANTITY_RECEIVED QUANTITY_RECEIVED, QUANTITY_INVOICED QUANTITY_INVOICED, AMOUNT_RECEIVED AMOUNT_RECEIVED, AMOUNT_INVOICED AMOUNT_INVOICED, LCM_ACCOUNT_ID LCM_ACCOUNT_ID, UNIT_LANDED_COST UNIT_LANDED_COST from "PO"."RCV_ACCOUNTING_EVENTS"

View Text - HTML Formatted

SELECT ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_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_UDPATE_DATE PROGRAM_UDPATE_DATE
, RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, EVENT_TYPE_ID EVENT_TYPE_ID
, EVENT_SOURCE EVENT_SOURCE
, EVENT_SOURCE_ID EVENT_SOURCE_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ORG_ID ORG_ID
, TRANSFER_ORG_ID TRANSFER_ORG_ID
, ORGANIZATION_ID ORGANIZATION_ID
, TRANSFER_ORGANIZATION_ID TRANSFER_ORGANIZATION_ID
, DEBIT_ACCOUNT_ID DEBIT_ACCOUNT_ID
, CREDIT_ACCOUNT_ID CREDIT_ACCOUNT_ID
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, TRANSACTION_UNIT_OF_MEASURE TRANSACTION_UNIT_OF_MEASURE
, SOURCE_DOC_QUANTITY SOURCE_DOC_QUANTITY
, SOURCE_DOC_UNIT_OF_MEASURE SOURCE_DOC_UNIT_OF_MEASURE
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PO_HEADER_ID PO_HEADER_ID
, PO_RELEASE_ID PO_RELEASE_ID
, PO_LINE_ID PO_LINE_ID
, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, INTERCOMPANY_PRICING_OPTION INTERCOMPANY_PRICING_OPTION
, UNIT_PRICE UNIT_PRICE
, TRANSACTION_AMOUNT TRANSACTION_AMOUNT
, PRIOR_UNIT_PRICE PRIOR_UNIT_PRICE
, NR_TAX NR_TAX
, REC_TAX REC_TAX
, NR_TAX_AMOUNT NR_TAX_AMOUNT
, REC_TAX_AMOUNT REC_TAX_AMOUNT
, PRIOR_NR_TAX PRIOR_NR_TAX
, PRIOR_REC_TAX PRIOR_REC_TAX
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, ACCOUNTED_FLAG ACCOUNTED_FLAG
, PROCUREMENT_ORG_FLAG PROCUREMENT_ORG_FLAG
, CROSS_OU_FLAG CROSS_OU_FLAG
, TRX_FLOW_HEADER_ID TRX_FLOW_HEADER_ID
, INVOICED_FLAG INVOICED_FLAG
, PA_ADDITION_FLAG PA_ADDITION_FLAG
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, GL_GROUP_ID GL_GROUP_ID
, QUANTITY_RECEIVED QUANTITY_RECEIVED
, QUANTITY_INVOICED QUANTITY_INVOICED
, AMOUNT_RECEIVED AMOUNT_RECEIVED
, AMOUNT_INVOICED AMOUNT_INVOICED
, LCM_ACCOUNT_ID LCM_ACCOUNT_ID
, UNIT_LANDED_COST UNIT_LANDED_COST
FROM "PO"."RCV_ACCOUNTING_EVENTS"