eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: POBV_RECEIVING_TRANSACTIONS

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POBV_RECEIVING_TRANSACTIONS

View Text

SELECT RT.TRANSACTION_ID
, '_LA:RT.TRANSACTION_TYPE:PO_LOOKUP_CODES:RCV TRANSACTION TYPE:DISPLAYED_FIELD'
, RT.TRANSACTION_DATE
, RT.QUANTITY
, RT.COMMENTS
, RT.CURRENCY_CONVERSION_RATE
, RT.CURRENCY_CONVERSION_DATE
, '_LA:RT.DESTINATION_TYPE_CODE:PO_LOOKUP_CODES:RCV DESTINATION TYPE:DISPLAYED_FIELD'
, RT.INSPECTION_QUALITY_CODE
, '_LA:RT.INSPECTION_STATUS_CODE:PO_LOOKUP_CODES:INSPECTION STATUS:DISPLAYED_FIELD'
, RT.INVOICE_STATUS_CODE
, RT.PRIMARY_QUANTITY
, RT.SOURCE_DOC_QUANTITY
, RT.PO_UNIT_PRICE
, '_LA:RT.RECEIPT_EXCEPTION_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RT.RMA_REFERENCE
, '_LA:RT.SOURCE_DOCUMENT_CODE:PO_LOOKUP_CODES:SHIPMENT SOURCE DOCUMENT TYPE:DISPLAYED_FIELD'
, RT.SUBSTITUTE_UNORDERED_CODE
, RT.VENDOR_LOT_NUM
, '_LA:RT.USER_ENTERED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RE.REASON_NAME
, RT.SHIPMENT_HEADER_ID
, RT.SHIPMENT_LINE_ID
, RT.INV_TRANSACTION_ID
, RT.UNIT_OF_MEASURE
, RT.PRIMARY_UNIT_OF_MEASURE
, RT.SOURCE_DOC_UNIT_OF_MEASURE
, RT.EMPLOYEE_ID
, RT.PARENT_TRANSACTION_ID
, RT.PO_HEADER_ID
, RT.PO_RELEASE_ID
, RT.PO_LINE_ID
, RT.PO_LINE_LOCATION_ID
, RT.PO_DISTRIBUTION_ID
, RT.REQUISITION_LINE_ID
, RT.REQ_DISTRIBUTION_ID
, RT.CURRENCY_CODE
, RT.CURRENCY_CONVERSION_TYPE
, RT.ROUTING_HEADER_ID
, RT.ROUTING_STEP_ID
, RT.DELIVER_TO_PERSON_ID
, RT.DELIVER_TO_LOCATION_ID
, RT.VENDOR_ID
, RT.VENDOR_SITE_ID
, RT.ORGANIZATION_ID
, RT.SUBINVENTORY
, RT.LOCATOR_ID
, RT.BOM_RESOURCE_ID
, RT.DEPARTMENT_CODE
, RT.WIP_ENTITY_ID
, RT.WIP_LINE_ID
, RT.WIP_OPERATION_SEQ_NUM
, RT.WIP_REPETITIVE_SCHEDULE_ID
, RT.WIP_RESOURCE_SEQ_NUM
, RT.INVOICE_ID
, RT.CREATION_DATE
, RT.CREATED_BY
, RT.LAST_UPDATE_DATE
, RT.LAST_UPDATED_BY
, RT.MVT_STAT_STATUS
, RT.QUANTITY_BILLED
, RT.AMOUNT_BILLED
, '_LA:RT.MATCH_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RT.MATCH_OPTION
, RT.SECONDARY_QUANTITY
, RT.SECONDARY_UNIT_OF_MEASURE
, RT.SECONDARY_UOM_CODE
, RT.QC_GRADE
, '_LA:RT.PA_ADDITION_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:RT.CONSIGNED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
FROM RCV_TRANSACTIONS RT
, MTL_TRANSACTION_REASONS RE
WHERE RT.REASON_ID = RE.REASON_ID(+) WITH READ ONLY

Columns

Name
TRANSACTION_ID
"_LA:TRANSACTION_TYPE"
TRANSACTION_DATE
TRANSACTION_QUANTITY
COMMENTS
CURRENCY_CONVERSION_RATE
CURRENCY_CONVERSION_RATE_DATE
"_LA:DESTINATION_TYPE"
INSPECTION_QUALITY
"_LA:INSPECTION_STATUS"
INVOICE_STATUS
PRIMARY_QUANTITY
SOURCE_DOCUMENT_QUANTITY
PURCHASE_ORDER_UNIT_PRICE
"_LA:RECEIPT_EXCEPTION_FLAG"
RMA_REFERENCE_NUMBER
"_LA:SOURCE_DOCUMENT_TYPE"
SUBSTITUTE_UNORDERED_INDICATOR
SUPPLIER_LOT_NUMBER
"LA:USER_ENTERED_FLAG"
TRANSACTION_REASON_NAME
SHIPMENT_ID
SHIPMENT_LINE_ID
INVENTORY_TRANSACTION_ID
TRANSACTION_UNIT_OF_MEASURE
PRIMARY_UNIT_OF_MEASURE
SOURCE_DOC_UNIT_OF_MEASURE
RECEIVER_ID
PARENT_TRANSACTION_ID
PURCHASE_ORDER_ID
PO_RELEASE_ID
PO_LINE_ID
PO_SHIPMENT_ID
PO_DISTRIBUTION_ID
REQUISITION_LINE_ID
REQ_DISTRIBUTION_ID
CURRENCY_CODE
CURRENCY_CONVERSION_RATE_TYPE
RECEIVING_ROUTING_ID
ROUTING_STEP_ID
DELIVER_TO_PERSON_ID
DELIVER_TO_LOCATION_ID
SUPPLIER_ID
SUPPLIER_SITE_ID
DESTINATION_ORGANIZATION_ID
DESTINATION_SUBINVENTORY
DESTINATION_LOCATOR_ID
BILL_OF_MATERIAL_RESOURCE_ID
WIP_DEPARTMENT_CODE
WIP_ENTITY_ID
WIP_LINE_ID
WIP_OPERATION_SEQUENCE_NUMBER
WIP_REPETITIVE_SCHEDULE_ID
WIP_RESOURCE_SEQUENCE_NUMBER
INVOICE_ID
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY
MVT_STAT_STATUS
QUANTITY_BILLED
AMOUNT_BILLED
"_LA:MATCH_FLAG"
MATCH_OPTION
SECONDARY_QUANTITY
SECONDARY_UNIT_OF_MEASURE
SECONDARY_UOM_CODE
QC_GRADE
"_LA:PA_ADDITION_FLAG"
"_LA:CONSIGNED_FLAG"