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_PERIODIC_ABSORPTION_PROC dependencies on MTL_MATERIAL_TRANSACTIONS

Line 574: FROM mtl_material_transactions mmt

570: , mmt.primary_quantity
571: , mmt.organization_id
572: , nvl(mmt.transfer_organization_id,-1) transfer_organization_id
573: , mmt.subinventory_code
574: FROM mtl_material_transactions mmt
575: WHERE mmt.transaction_date BETWEEN c_start_date AND c_end_date
576: AND mmt.transaction_action_id = 24
577: AND mmt.transaction_source_type_id = 14
578: AND value_change IS NOT NULL

Line 1763: FROM mtl_material_transactions mmt

1759: , mmt.organization_id
1760: , nvl(mmt.transfer_organization_id,-1) transfer_organization_id
1761: , mmt.subinventory_code
1762: , nvl(mmt.transfer_price,0) transfer_price
1763: FROM mtl_material_transactions mmt
1764: WHERE transaction_date between c_period_start_date AND c_period_end_date
1765: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
1766: AND mmt.inventory_item_id = c_inventory_item_id
1767: AND nvl(mmt.owning_tp_type,2) = 2

Line 1860: FROM mtl_material_transactions mmt

1856: , mmt.organization_id
1857: , nvl(mmt.transfer_organization_id,-1) transfer_organization_id
1858: , mmt.subinventory_code
1859: , nvl(mmt.transfer_price,0) transfer_price
1860: FROM mtl_material_transactions mmt
1861: WHERE transaction_date between c_period_start_date AND c_period_end_date
1862: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
1863: AND mmt.inventory_item_id = c_inventory_item_id
1864: AND nvl(mmt.owning_tp_type,2) = 2

Line 1900: mtl_material_transactions mmt

1896: , nvl(mmt.transfer_organization_id,-1) transfer_organization_id
1897: , mmt.subinventory_code
1898: , nvl(mmt.transfer_price,0) transfer_price
1899: FROM
1900: mtl_material_transactions mmt
1901: , cst_cost_group_assignments ccga
1902: WHERE transaction_date between c_period_start_date AND c_period_end_date
1903: AND transaction_action_id in (4,8,28,33,34,1,2,5,27)
1904: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)

Line 1952: FROM mtl_material_transactions mmt

1948: , mmt.organization_id
1949: , nvl(mmt.transfer_organization_id,-1) transfer_organization_id
1950: , mmt.subinventory_code
1951: , nvl(mmt.transfer_price,0) transfer_price
1952: FROM mtl_material_transactions mmt
1953: WHERE transaction_date between c_period_start_date AND c_period_end_date
1954: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
1955: AND mmt.inventory_item_id = c_inventory_item_id
1956: AND nvl(mmt.owning_tp_type,2) = 2

Line 2049: FROM mtl_material_transactions mmt

2045: , mmt.organization_id
2046: , nvl(mmt.transfer_organization_id,-1) transfer_organization_id
2047: , mmt.subinventory_code
2048: , nvl(mmt.transfer_price,0) transfer_price
2049: FROM mtl_material_transactions mmt
2050: WHERE transaction_date between c_period_start_date AND c_period_end_date
2051: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
2052: AND mmt.inventory_item_id = c_inventory_item_id
2053: AND nvl(mmt.owning_tp_type,2) = 2

Line 2089: mtl_material_transactions mmt

2085: , nvl(mmt.transfer_organization_id,-1) transfer_organization_id
2086: , mmt.subinventory_code
2087: , nvl(mmt.transfer_price,0) transfer_price
2088: FROM
2089: mtl_material_transactions mmt
2090: , cst_cost_group_assignments ccga
2091: WHERE transaction_date between c_period_start_date AND c_period_end_date
2092: AND transaction_action_id in (4,8,28,33,34,1,2,5,27)
2093: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)

Line 2782: SELECT /+ leading (MMT) INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N5)/

2778: ,pac_period_id
2779: ,absorption_level_code
2780: ,process_flag
2781: )
2782: SELECT /*+ leading (MMT) INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N5)*/
2783: distinct(mmt.inventory_item_id)
2784: ,p_period_id
2785: ,1000
2786: ,'N'

Line 2787: FROM mtl_material_transactions mmt, cst_cost_groups ccg, cst_cost_group_assignments ccga

2783: distinct(mmt.inventory_item_id)
2784: ,p_period_id
2785: ,1000
2786: ,'N'
2787: FROM mtl_material_transactions mmt, cst_cost_groups ccg, cst_cost_group_assignments ccga
2788: WHERE mmt.transaction_date between p_period_start_date AND p_period_end_date
2789: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
2790: AND nvl(mmt.owning_tp_type,2) = 2
2791: AND ccg.legal_entity = p_legal_entity_id

Line 3057: FROM mtl_material_transactions_temp mmtt

3053: l_count_rows := 0;
3054:
3055: SELECT count(1)
3056: INTO l_count_rows
3057: FROM mtl_material_transactions_temp mmtt
3058: WHERE NVL(mmtt.transaction_status,0) <> 2
3059: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(mmtt.organization_id) = 'Y'
3060: AND mmtt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3061: AND ROWNUM = 1;

Line 3157: FROM mtl_material_transactions mmt

3153: l_count_rows := 0;
3154:
3155: SELECT count(1)
3156: INTO l_count_rows
3157: FROM mtl_material_transactions mmt
3158: WHERE mmt.creation_date > ( SELECT MIN(cppp.process_date)
3159: FROM cst_pac_process_phases cppp
3160: WHERE
3161: ( (cppp.process_phase <= 4 OR cppp.process_phase = 7)

Line 4167: mtl_material_transactions mmt

4163: , mmt.organization_id
4164: , nvl(mmt.transfer_organization_id,-1) transfer_organization_id
4165: , mmt.subinventory_code
4166: FROM
4167: mtl_material_transactions mmt
4168: , cst_cost_group_assignments ccga
4169: WHERE mmt.transaction_date BETWEEN c_start_date AND c_end_date
4170: AND ccga.organization_id = mmt.organization_id
4171: AND ccga.cost_group_id = c_cost_group_id