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 555: FROM mtl_material_transactions mmt

551: , mmt.primary_quantity
552: , mmt.organization_id
553: , nvl(mmt.transfer_organization_id,-1) transfer_organization_id
554: , mmt.subinventory_code
555: FROM mtl_material_transactions mmt
556: WHERE mmt.transaction_date BETWEEN c_start_date AND c_end_date
557: AND mmt.transaction_action_id = 24
558: AND mmt.transaction_source_type_id = 14
559: AND mmt.transaction_type_id = 26/*Added for bug 16056585*/

Line 1761: FROM mtl_material_transactions mmt

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

Line 1858: FROM mtl_material_transactions mmt

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

Line 1898: mtl_material_transactions mmt

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

Line 1950: FROM mtl_material_transactions mmt

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

Line 2047: FROM mtl_material_transactions mmt

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

Line 2087: mtl_material_transactions mmt

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

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

2783: ,1000
2784: ,'N'
2785: FROM
2786: (
2787: SELECT /*+ leading (MMT) INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N5)*/
2788: mmt.inventory_item_id inventory_item_id
2789: FROM mtl_material_transactions mmt, cst_cost_groups ccg, cst_cost_group_assignments ccga
2790: WHERE mmt.transaction_date between p_period_start_date AND p_period_end_date
2791: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)

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

2785: FROM
2786: (
2787: SELECT /*+ leading (MMT) INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N5)*/
2788: mmt.inventory_item_id inventory_item_id
2789: FROM mtl_material_transactions mmt, cst_cost_groups ccg, cst_cost_group_assignments ccga
2790: WHERE mmt.transaction_date between p_period_start_date AND p_period_end_date
2791: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
2792: AND nvl(mmt.owning_tp_type,2) = 2
2793: AND ccg.legal_entity = p_legal_entity_id

Line 2802: FROM mtl_material_transactions mmt, cst_pac_periods cpp, cst_cost_groups ccg

2798: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
2799: AND cpllc.pac_period_id = p_period_id)
2800: UNION ALL
2801: SELECT mmt.inventory_item_id inventory_item_id
2802: FROM mtl_material_transactions mmt, cst_pac_periods cpp, cst_cost_groups ccg
2803: WHERE mmt.transaction_date between p_period_start_date AND p_period_end_date
2804: AND mmt.transaction_action_id = 24
2805: AND mmt.transaction_source_type_id = 14
2806: AND mmt.transaction_type_id = 26

Line 2819: SELECT /+ ORDERED INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N5)/

2815: FROM cst_pac_low_level_codes cpllc
2816: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
2817: AND cpllc.pac_period_id = p_period_id)
2818: UNION ALL
2819: SELECT /*+ ORDERED INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N5)*/
2820: mmt.inventory_item_id inventory_item_id
2821: FROM cst_cost_groups ccg,
2822: cst_cost_group_assignments ccga,
2823: mtl_interorg_parameters mip,

Line 2824: mtl_material_transactions mmt

2820: mmt.inventory_item_id inventory_item_id
2821: FROM cst_cost_groups ccg,
2822: cst_cost_group_assignments ccga,
2823: mtl_interorg_parameters mip,
2824: mtl_material_transactions mmt
2825: WHERE mmt.transaction_date between p_period_start_date AND p_period_end_date
2826: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
2827: AND nvl(mmt.owning_tp_type,2) = 2
2828: AND ccg.legal_entity = p_legal_entity_id

Line 3112: FROM mtl_material_transactions_temp mmtt

3108: l_count_rows := 0;
3109:
3110: SELECT count(1)
3111: INTO l_count_rows
3112: FROM mtl_material_transactions_temp mmtt
3113: WHERE NVL(mmtt.transaction_status,0) <> 2
3114: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(mmtt.organization_id) = 'Y'
3115: AND mmtt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3116: AND ROWNUM = 1;

Line 3212: FROM mtl_material_transactions mmt

3208: l_count_rows := 0;
3209:
3210: SELECT count(1)
3211: INTO l_count_rows
3212: FROM mtl_material_transactions mmt
3213: WHERE mmt.creation_date > ( SELECT MIN(cppp.process_date)
3214: FROM cst_pac_process_phases cppp
3215: WHERE
3216: ( (cppp.process_phase <= 4 OR cppp.process_phase = 7)

Line 4536: mtl_material_transactions mmt

4532: , mmt.organization_id
4533: , nvl(mmt.transfer_organization_id,-1) transfer_organization_id
4534: , mmt.subinventory_code
4535: FROM
4536: mtl_material_transactions mmt
4537: , cst_cost_group_assignments ccga
4538: WHERE mmt.transaction_date BETWEEN c_start_date AND c_end_date
4539: AND ccga.organization_id = mmt.organization_id
4540: AND ccga.cost_group_id = c_cost_group_id