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.

APPS.CST_INVENTORY_PVT dependencies on RCV_TRANSACTIONS

Line 1353: rcv_transactions RT

1349: cst_item_list_temp ITEMS,
1350: cst_cg_list_temp CGS,
1351: mtl_interorg_parameters MIP,
1352: mtl_system_items MSI_FROM,
1353: rcv_transactions RT
1354: WHERE MMT.organization_id = p_organization_id
1355: AND MMT.transaction_action_id = 12
1356: AND MMT.costed_flag IN ('N', 'E')
1357: AND MMT.inventory_item_id = ITEMS.inventory_item_id

Line 1555: rcv_transactions RT

1551: cst_item_list_temp ITEMS,
1552: cst_cg_list_temp CGS,
1553: mtl_interorg_parameters MIP,
1554: mtl_system_items MSI_FROM,
1555: rcv_transactions RT
1556: WHERE MMT.organization_id = p_organization_id
1557: AND MMT.transaction_action_id = 12
1558: AND MMT.costed_flag IS NULL
1559: AND MMT.transaction_date > p_valuation_date

Line 1860: rcv_transactions RT

1856: cst_item_list_temp ITEMS,
1857: cst_cg_list_temp CGS,
1858: mtl_interorg_parameters MIP,
1859: mtl_system_items MSI_FROM,
1860: rcv_transactions RT
1861: WHERE MMT.transfer_organization_id = p_organization_id
1862: AND MMT.transaction_action_id = 12
1863: AND MMT.costed_flag IN ('N', 'E')
1864: AND MMT.inventory_item_id = ITEMS.inventory_item_id

Line 2062: rcv_transactions RT

2058: cst_item_list_temp ITEMS,
2059: cst_cg_list_temp CGS,
2060: mtl_interorg_parameters MIP,
2061: mtl_system_items MSI_FROM,
2062: rcv_transactions RT
2063: WHERE MMT.transfer_organization_id = p_organization_id
2064: AND MMT.transaction_action_id = 12
2065: AND MMT.costed_flag IS NULL
2066: AND MMT.transaction_date > p_valuation_date

Line 3178: rcv_transactions RT,

3174: SUM(MS.to_org_primary_quantity) -- sum across po distributions
3175: FROM cst_item_list_temp CILT,
3176: cst_cg_list_temp CCLT,
3177: mtl_supply MS,
3178: rcv_transactions RT,
3179: mtl_parameters MP,
3180: po_lines_all POL,
3181: po_line_locations_all POLL,
3182: pjm_project_parameters PPP

Line 3277: rcv_transactions RT,

3273: 0)
3274: ) rollback_qty
3275: FROM cst_item_list_temp CILT,
3276: cst_cg_list_temp CCLT,
3277: rcv_transactions RT,
3278: rcv_transactions PARENT_RT,
3279: rcv_transactions GRPARENT_RT,
3280: mtl_parameters MP,
3281: po_lines_all POL,

Line 3278: rcv_transactions PARENT_RT,

3274: ) rollback_qty
3275: FROM cst_item_list_temp CILT,
3276: cst_cg_list_temp CCLT,
3277: rcv_transactions RT,
3278: rcv_transactions PARENT_RT,
3279: rcv_transactions GRPARENT_RT,
3280: mtl_parameters MP,
3281: po_lines_all POL,
3282: po_line_locations_all POLL,

Line 3279: rcv_transactions GRPARENT_RT,

3275: FROM cst_item_list_temp CILT,
3276: cst_cg_list_temp CCLT,
3277: rcv_transactions RT,
3278: rcv_transactions PARENT_RT,
3279: rcv_transactions GRPARENT_RT,
3280: mtl_parameters MP,
3281: po_lines_all POL,
3282: po_line_locations_all POLL,
3283: pjm_project_parameters PPP

Line 3382: FROM rcv_transactions RT

3378: FROM (
3379: SELECT RT.transaction_id transaction_id,
3380: RT.parent_transaction_id parent_transaction_id,
3381: RT.transaction_type
3382: FROM rcv_transactions RT
3383: START WITH transaction_id = p_rcv_transaction_id
3384: CONNECT BY transaction_id = PRIOR parent_transaction_id)
3385: WHERE ((transaction_type = 'RECEIVE' and parent_transaction_id=-1)
3386: OR transaction_type = 'MATCH');