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.

VIEW: APPS.RCV_FTE_TRANSACTIONS_V

Source

View Text - Preformatted


SELECT rt.transaction_id, to_number(null) parent_transaction_id, to_char(null) parent_transaction_type, DECODE(rt.transaction_type, 'MATCH', 'RECEIPT', rt.transaction_type) transaction_type, rt.transaction_date, rt.shipment_line_id, rt.po_unit_price, rt.currency_code, rt.qc_grade, rt.country_of_origin_code, rt.lpn_id, rt.locator_id, rt.subinventory, rt.quantity, muom.uom_code uom_code, rt.primary_quantity, primary_muom.uom_code primary_uom_code, rt.secondary_quantity, secondary_muom.uom_code secondary_uom_code, rt.last_update_date, rt.last_updated_by, rt.creation_date, rt.created_by, rt.last_update_login FROM rcv_transactions rt, mtl_units_of_measure muom, mtl_units_of_measure primary_muom, mtl_units_of_measure secondary_muom WHERE rt.unit_of_measure = muom.unit_of_measure(+) AND rt.primary_unit_of_measure = primary_muom.unit_of_measure (+) AND rt.secondary_unit_of_measure = secondary_muom.unit_of_measure(+) AND rt.transaction_type IN ('RECEIVE', 'MATCH') UNION ALL SELECT rt.transaction_id, return_parents.transaction_id parent_transaction_id, return_parents.transaction_type parent_transaction_type, rt.transaction_type, rt.transaction_date, rt.shipment_line_id, rt.po_unit_price, rt.currency_code, rt.qc_grade, rt.country_of_origin_code, rt.lpn_id, rt.locator_id, rt.subinventory, rt.quantity, muom.uom_code uom_code, rt.primary_quantity, primary_muom.uom_code primary_uom_code, rt.secondary_quantity, secondary_muom.uom_code secondary_uom_code, rt.last_update_date, rt.last_updated_by, rt.creation_date, rt.created_by, rt.last_update_login FROM rcv_transactions rt, (SELECT a.transaction_id root_transaction, b.transaction_id, 'RECEIVE' transaction_type FROM rcv_transactions a, rcv_transactions b WHERE a.transaction_type = 'RETURN TO VENDOR' and b.transaction_id = ( SELECT c.transaction_id FROM rcv_transactions c WHERE c.transaction_type IN ('RECEIVE', 'MATCH') START WITH c.transaction_type = 'RETURN TO VENDOR' AND a.transaction_id = c.transaction_id CONNECT BY PRIOR c.parent_transaction_id = c.transaction_id) ) return_parents, mtl_units_of_measure muom, mtl_units_of_measure primary_muom, mtl_units_of_measure secondary_muom WHERE rt.unit_of_measure = muom.unit_of_measure(+) AND rt.primary_unit_of_measure = primary_muom.unit_of_measure (+) AND rt.secondary_unit_of_measure = secondary_muom.unit_of_measure(+) AND rt.transaction_type = 'RETURN TO VENDOR' AND return_parents.root_transaction = rt.transaction_id UNION ALL SELECT rt.transaction_id, parent_transaction.transaction_id parent_transaction_id, parent_transaction.transaction_type parent_transaction_type, rt.transaction_type, rt.transaction_date, rt.shipment_line_id, rt.po_unit_price, rt.currency_code, rt.qc_grade, rt.country_of_origin_code, rt.lpn_id, rt.locator_id, rt.subinventory, rt.quantity, muom.uom_code uom_code, rt.primary_quantity, primary_muom.uom_code primary_uom_code, rt.secondary_quantity, secondary_muom.uom_code secondary_uom_code, rt.last_update_date, rt.last_updated_by, rt.creation_date, rt.created_by, rt.last_update_login FROM rcv_transactions rt, rcv_transactions parent_transaction, mtl_units_of_measure muom, mtl_units_of_measure primary_muom, mtl_units_of_measure secondary_muom WHERE rt.unit_of_measure = muom.unit_of_measure (+) AND rt.primary_unit_of_measure = primary_muom.unit_of_measure (+) AND rt.secondary_unit_of_measure = secondary_muom.unit_of_measure (+) AND rt.transaction_type = 'CORRECT' AND rt.parent_transaction_id = parent_transaction.transaction_id AND parent_transaction.transaction_type IN ('RECEIVE', 'RETURN TO VENDOR', 'MATCH')

View Text - HTML Formatted

SELECT RT.TRANSACTION_ID
, TO_NUMBER(NULL) PARENT_TRANSACTION_ID
, TO_CHAR(NULL) PARENT_TRANSACTION_TYPE
, DECODE(RT.TRANSACTION_TYPE
, 'MATCH'
, 'RECEIPT'
, RT.TRANSACTION_TYPE) TRANSACTION_TYPE
, RT.TRANSACTION_DATE
, RT.SHIPMENT_LINE_ID
, RT.PO_UNIT_PRICE
, RT.CURRENCY_CODE
, RT.QC_GRADE
, RT.COUNTRY_OF_ORIGIN_CODE
, RT.LPN_ID
, RT.LOCATOR_ID
, RT.SUBINVENTORY
, RT.QUANTITY
, MUOM.UOM_CODE UOM_CODE
, RT.PRIMARY_QUANTITY
, PRIMARY_MUOM.UOM_CODE PRIMARY_UOM_CODE
, RT.SECONDARY_QUANTITY
, SECONDARY_MUOM.UOM_CODE SECONDARY_UOM_CODE
, RT.LAST_UPDATE_DATE
, RT.LAST_UPDATED_BY
, RT.CREATION_DATE
, RT.CREATED_BY
, RT.LAST_UPDATE_LOGIN
FROM RCV_TRANSACTIONS RT
, MTL_UNITS_OF_MEASURE MUOM
, MTL_UNITS_OF_MEASURE PRIMARY_MUOM
, MTL_UNITS_OF_MEASURE SECONDARY_MUOM
WHERE RT.UNIT_OF_MEASURE = MUOM.UNIT_OF_MEASURE(+)
AND RT.PRIMARY_UNIT_OF_MEASURE = PRIMARY_MUOM.UNIT_OF_MEASURE (+)
AND RT.SECONDARY_UNIT_OF_MEASURE = SECONDARY_MUOM.UNIT_OF_MEASURE(+)
AND RT.TRANSACTION_TYPE IN ('RECEIVE'
, 'MATCH') UNION ALL SELECT RT.TRANSACTION_ID
, RETURN_PARENTS.TRANSACTION_ID PARENT_TRANSACTION_ID
, RETURN_PARENTS.TRANSACTION_TYPE PARENT_TRANSACTION_TYPE
, RT.TRANSACTION_TYPE
, RT.TRANSACTION_DATE
, RT.SHIPMENT_LINE_ID
, RT.PO_UNIT_PRICE
, RT.CURRENCY_CODE
, RT.QC_GRADE
, RT.COUNTRY_OF_ORIGIN_CODE
, RT.LPN_ID
, RT.LOCATOR_ID
, RT.SUBINVENTORY
, RT.QUANTITY
, MUOM.UOM_CODE UOM_CODE
, RT.PRIMARY_QUANTITY
, PRIMARY_MUOM.UOM_CODE PRIMARY_UOM_CODE
, RT.SECONDARY_QUANTITY
, SECONDARY_MUOM.UOM_CODE SECONDARY_UOM_CODE
, RT.LAST_UPDATE_DATE
, RT.LAST_UPDATED_BY
, RT.CREATION_DATE
, RT.CREATED_BY
, RT.LAST_UPDATE_LOGIN
FROM RCV_TRANSACTIONS RT
, (SELECT A.TRANSACTION_ID ROOT_TRANSACTION
, B.TRANSACTION_ID
, 'RECEIVE' TRANSACTION_TYPE
FROM RCV_TRANSACTIONS A
, RCV_TRANSACTIONS B
WHERE A.TRANSACTION_TYPE = 'RETURN TO VENDOR'
AND B.TRANSACTION_ID = ( SELECT C.TRANSACTION_ID
FROM RCV_TRANSACTIONS C
WHERE C.TRANSACTION_TYPE IN ('RECEIVE'
, 'MATCH') START WITH C.TRANSACTION_TYPE = 'RETURN TO VENDOR'
AND A.TRANSACTION_ID = C.TRANSACTION_ID CONNECT BY PRIOR C.PARENT_TRANSACTION_ID = C.TRANSACTION_ID) ) RETURN_PARENTS
, MTL_UNITS_OF_MEASURE MUOM
, MTL_UNITS_OF_MEASURE PRIMARY_MUOM
, MTL_UNITS_OF_MEASURE SECONDARY_MUOM
WHERE RT.UNIT_OF_MEASURE = MUOM.UNIT_OF_MEASURE(+)
AND RT.PRIMARY_UNIT_OF_MEASURE = PRIMARY_MUOM.UNIT_OF_MEASURE (+)
AND RT.SECONDARY_UNIT_OF_MEASURE = SECONDARY_MUOM.UNIT_OF_MEASURE(+)
AND RT.TRANSACTION_TYPE = 'RETURN TO VENDOR'
AND RETURN_PARENTS.ROOT_TRANSACTION = RT.TRANSACTION_ID UNION ALL SELECT RT.TRANSACTION_ID
, PARENT_TRANSACTION.TRANSACTION_ID PARENT_TRANSACTION_ID
, PARENT_TRANSACTION.TRANSACTION_TYPE PARENT_TRANSACTION_TYPE
, RT.TRANSACTION_TYPE
, RT.TRANSACTION_DATE
, RT.SHIPMENT_LINE_ID
, RT.PO_UNIT_PRICE
, RT.CURRENCY_CODE
, RT.QC_GRADE
, RT.COUNTRY_OF_ORIGIN_CODE
, RT.LPN_ID
, RT.LOCATOR_ID
, RT.SUBINVENTORY
, RT.QUANTITY
, MUOM.UOM_CODE UOM_CODE
, RT.PRIMARY_QUANTITY
, PRIMARY_MUOM.UOM_CODE PRIMARY_UOM_CODE
, RT.SECONDARY_QUANTITY
, SECONDARY_MUOM.UOM_CODE SECONDARY_UOM_CODE
, RT.LAST_UPDATE_DATE
, RT.LAST_UPDATED_BY
, RT.CREATION_DATE
, RT.CREATED_BY
, RT.LAST_UPDATE_LOGIN
FROM RCV_TRANSACTIONS RT
, RCV_TRANSACTIONS PARENT_TRANSACTION
, MTL_UNITS_OF_MEASURE MUOM
, MTL_UNITS_OF_MEASURE PRIMARY_MUOM
, MTL_UNITS_OF_MEASURE SECONDARY_MUOM
WHERE RT.UNIT_OF_MEASURE = MUOM.UNIT_OF_MEASURE (+)
AND RT.PRIMARY_UNIT_OF_MEASURE = PRIMARY_MUOM.UNIT_OF_MEASURE (+)
AND RT.SECONDARY_UNIT_OF_MEASURE = SECONDARY_MUOM.UNIT_OF_MEASURE (+)
AND RT.TRANSACTION_TYPE = 'CORRECT'
AND RT.PARENT_TRANSACTION_ID = PARENT_TRANSACTION.TRANSACTION_ID
AND PARENT_TRANSACTION.TRANSACTION_TYPE IN ('RECEIVE'
, 'RETURN TO VENDOR'
, 'MATCH')