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 1428: rcv_transactions RT

1424: cst_item_list_temp ITEMS,
1425: cst_cg_list_temp CGS,
1426: mtl_interorg_parameters MIP,
1427: mtl_system_items MSI_FROM,
1428: rcv_transactions RT
1429: WHERE MMT.organization_id = p_organization_id
1430: AND MMT.transaction_action_id = 12
1431: AND MMT.costed_flag IN ('N', 'E')
1432: AND MMT.inventory_item_id = ITEMS.inventory_item_id

Line 1636: rcv_transactions RT

1632: cst_item_list_temp ITEMS,
1633: cst_cg_list_temp CGS,
1634: mtl_interorg_parameters MIP,
1635: mtl_system_items MSI_FROM,
1636: rcv_transactions RT
1637: WHERE MMT.organization_id = p_organization_id
1638: AND MMT.transaction_action_id = 12
1639: AND MMT.costed_flag IS NULL
1640: AND MMT.transaction_date > p_valuation_date

Line 1939: rcv_transactions RT

1935: cst_item_list_temp ITEMS,
1936: cst_cg_list_temp CGS,
1937: mtl_interorg_parameters MIP,
1938: mtl_system_items MSI_FROM,
1939: rcv_transactions RT
1940: WHERE Decode(MMT.transaction_action_id, 12, MMT.transfer_organization_id, 22, MMT.organization_id) = p_organization_id
1941: AND MMT.transaction_action_id IN (12,22)
1942: AND MMT.costed_flag IN ('N', 'E')
1943: AND MMT.inventory_item_id = ITEMS.inventory_item_id

Line 2135: rcv_transactions RT

2131: cst_item_list_temp ITEMS,
2132: cst_cg_list_temp CGS,
2133: mtl_interorg_parameters MIP,
2134: mtl_system_items MSI_FROM,
2135: rcv_transactions RT
2136: WHERE MMT.transfer_organization_id = p_organization_id
2137: AND MMT.transaction_action_id = 12
2138: AND MMT.costed_flag IS NULL
2139: /* Bug 9764385: Modified the query to include Logical Intransit transactions */

Line 3273: rcv_transactions RT,

3269: SUM(MS.to_org_primary_quantity) -- sum across po distributions
3270: FROM cst_item_list_temp CILT,
3271: cst_cg_list_temp CCLT,
3272: mtl_supply MS,
3273: rcv_transactions RT,
3274: mtl_parameters MP,
3275: po_lines_all POL,
3276: po_line_locations_all POLL,
3277: pjm_project_parameters PPP

Line 3373: rcv_transactions RT,

3369: 0)
3370: ) rollback_qty
3371: FROM cst_item_list_temp CILT,
3372: cst_cg_list_temp CCLT,
3373: rcv_transactions RT,
3374: rcv_transactions PARENT_RT,
3375: rcv_transactions GRPARENT_RT,
3376: mtl_parameters MP,
3377: po_lines_all POL,

Line 3374: rcv_transactions PARENT_RT,

3370: ) rollback_qty
3371: FROM cst_item_list_temp CILT,
3372: cst_cg_list_temp CCLT,
3373: rcv_transactions RT,
3374: rcv_transactions PARENT_RT,
3375: rcv_transactions GRPARENT_RT,
3376: mtl_parameters MP,
3377: po_lines_all POL,
3378: po_line_locations_all POLL,

Line 3375: rcv_transactions GRPARENT_RT,

3371: FROM cst_item_list_temp CILT,
3372: cst_cg_list_temp CCLT,
3373: rcv_transactions RT,
3374: rcv_transactions PARENT_RT,
3375: rcv_transactions GRPARENT_RT,
3376: mtl_parameters MP,
3377: po_lines_all POL,
3378: po_line_locations_all POLL,
3379: pjm_project_parameters PPP

Line 3479: FROM rcv_transactions RT

3475: FROM (
3476: SELECT RT.transaction_id transaction_id,
3477: RT.parent_transaction_id parent_transaction_id,
3478: RT.transaction_type
3479: FROM rcv_transactions RT
3480: START WITH transaction_id = p_rcv_transaction_id
3481: CONNECT BY transaction_id = PRIOR parent_transaction_id)
3482: WHERE ((transaction_type = 'RECEIVE' and parent_transaction_id=-1)
3483: OR transaction_type = 'MATCH');