VIEW: APPS.POBV_RECEIVING_TRANSACTIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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