VIEW: APPS.POA_DBI_RTX_F_V

Source

View Text - Preformatted

SELECT TRANSACTION_ID, TRANSACTION_TYPE, PARENT_TRANSACTION_TYPE, GRP_TXN_DATE, RECEIVE_TXN_DATE, SUPPLIER_ID, SUPPLIER_SITE_ID, CREATION_OPERATING_UNIT_ID, RECEIVING_ORG_ID, REASON_ID, TRANSACTION_DATE, RCV_CREATION_DATE, QUANTITY, FUNC_CUR_CODE, GLOBAL_CUR_CONV_RATE, LINE_LOCATION_ID, SHIPMENT_HEADER_ID, SHIPMENT_LINE_ID, ASN_TYPE, RECEIPT_NUM, CREATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, SGLOBAL_CUR_CONV_RATE, SOURCE_DOC_QUANTITY, RECEIPT_EXISTS, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE, SOURCE_DOCUMENT_CODE, SHIPPING_CONTROL, OE_ORDER_LINE_ID, REQUISITION_LINE_ID, ROUTING_HEADER_ID, INVENTORY_ITEM_ID, PRIMARY_QUANTITY, PRIMARY_UOM_CODE, WMS_ENABLED_FLAG, WMS_GRP_TXN_DATE, DROPSHIP_TYPE_CODE, INV_TRANSACTION_ID FROM POA_DBI_RTX_F

View Text - HTML Formatted

SELECT TRANSACTION_ID
, TRANSACTION_TYPE
, PARENT_TRANSACTION_TYPE
, GRP_TXN_DATE
, RECEIVE_TXN_DATE
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, CREATION_OPERATING_UNIT_ID
, RECEIVING_ORG_ID
, REASON_ID
, TRANSACTION_DATE
, RCV_CREATION_DATE
, QUANTITY
, FUNC_CUR_CODE
, GLOBAL_CUR_CONV_RATE
, LINE_LOCATION_ID
, SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID
, ASN_TYPE
, RECEIPT_NUM
, CREATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, SGLOBAL_CUR_CONV_RATE
, SOURCE_DOC_QUANTITY
, RECEIPT_EXISTS
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, SOURCE_DOCUMENT_CODE
, SHIPPING_CONTROL
, OE_ORDER_LINE_ID
, REQUISITION_LINE_ID
, ROUTING_HEADER_ID
, INVENTORY_ITEM_ID
, PRIMARY_QUANTITY
, PRIMARY_UOM_CODE
, WMS_ENABLED_FLAG
, WMS_GRP_TXN_DATE
, DROPSHIP_TYPE_CODE
, INV_TRANSACTION_ID
FROM POA_DBI_RTX_F