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 MTL_MATERIAL_TRANSACTIONS

Line 793: FROM mtl_material_transactions MMT,

789: DECODE(p_qty_by_revision, 1, MMT.revision, NULL),
790: MMT.transaction_source_type_id,
791: CILT.category_id,
792: CILT.cost_type_id
793: FROM mtl_material_transactions MMT,
794: cst_item_list_temp CILT,
795: cst_cg_list_temp CCLT,
796: cst_sub_list_temp CSLT
797: WHERE MMT.organization_id = p_organization_id

Line 874: FROM mtl_material_transactions MMT,

870: DECODE(p_qty_by_revision, 1, MMT.revision, NULL),
871: MMT.transaction_source_type_id,
872: CILT.category_id,
873: CILT.cost_type_id
874: FROM mtl_material_transactions MMT,
875: cst_item_list_temp CILT
876: WHERE MMT.organization_id = p_organization_id
877: AND CILT.inventory_item_id = MMT.inventory_item_id
878: AND MMT.costed_flag IS NULL

Line 1063: SELECT /+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) / 1

1059: l_stmt_num := 5;
1060:
1061: DECLARE
1062: CURSOR c IS
1063: SELECT /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */ 1
1064: FROM mtl_material_transactions MMT
1065: WHERE mmt.costed_flag IN ('N','E')
1066: AND ( mmt.organization_id = p_organization_id
1067: OR mmt.transfer_organization_id = p_organization_id)

Line 1064: FROM mtl_material_transactions MMT

1060:
1061: DECLARE
1062: CURSOR c IS
1063: SELECT /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */ 1
1064: FROM mtl_material_transactions MMT
1065: WHERE mmt.costed_flag IN ('N','E')
1066: AND ( mmt.organization_id = p_organization_id
1067: OR mmt.transfer_organization_id = p_organization_id)
1068: AND ( mmt.transaction_action_id = 12

Line 1154: mtl_material_transactions MMT,

1150: cst_item_list_temp ITEMS,
1151: cst_cg_list_temp CGS,
1152: mtl_parameters MP,
1153: mtl_interorg_parameters MIP,
1154: mtl_material_transactions MMT,
1155: rcv_shipment_lines RSL,
1156: mtl_system_items MSI_FROM
1157: WHERE MS.to_organization_id = p_organization_id
1158: /* AND MS.intransit_owning_org_id = p_organization_id */ /* Bug 5664736 */

Line 1252: FROM mtl_material_transactions MMT,

1248: )
1249: ),
1250: NVL(MMT.intransit_account,MIP.intransit_inv_account),
1251: RSL.shipment_line_id
1252: FROM mtl_material_transactions MMT,
1253: cst_item_list_temp ITEMS,
1254: cst_cg_list_temp CGS,
1255: mtl_interorg_parameters MIP,
1256: mtl_system_items MSI_TO,

Line 1348: FROM mtl_material_transactions MMT,

1344: )
1345: ),
1346: NVL(MMT.intransit_account, MIP.intransit_inv_account),
1347: RT.shipment_line_id
1348: FROM mtl_material_transactions MMT,
1349: cst_item_list_temp ITEMS,
1350: cst_cg_list_temp CGS,
1351: mtl_interorg_parameters MIP,
1352: mtl_system_items MSI_FROM,

Line 1449: FROM mtl_material_transactions MMT,

1445: )
1446: ),
1447: NVL(MMT.intransit_account,MIP.intransit_inv_account),
1448: RSL.shipment_line_id
1449: FROM mtl_material_transactions MMT,
1450: cst_item_list_temp ITEMS,
1451: cst_cg_list_temp CGS,
1452: mtl_interorg_parameters MIP,
1453: mtl_system_items MSI_TO,

Line 1550: FROM mtl_material_transactions MMT,

1546: )
1547: ),
1548: NVL(MMT.intransit_account, MIP.intransit_inv_account),
1549: RT.shipment_line_id
1550: FROM mtl_material_transactions MMT,
1551: cst_item_list_temp ITEMS,
1552: cst_cg_list_temp CGS,
1553: mtl_interorg_parameters MIP,
1554: mtl_system_items MSI_FROM,

Line 1654: mtl_material_transactions MMT,

1650: cst_item_list_temp ITEMS,
1651: cst_cg_list_temp CGS,
1652: mtl_parameters MP,
1653: mtl_interorg_parameters MIP,
1654: mtl_material_transactions MMT,
1655: rcv_shipment_lines RSL,
1656: mtl_system_items MSI_FROM
1657: WHERE MS.from_organization_id = p_organization_id
1658: /* AND MS.intransit_owning_org_id = p_organization_id */ /* Bug 5664736 */

Line 1755: FROM mtl_material_transactions MMT,

1751: )
1752: ),
1753: NVL(MMT.intransit_account,MIP.intransit_inv_account),
1754: RSL.shipment_line_id
1755: FROM mtl_material_transactions MMT,
1756: cst_item_list_temp ITEMS,
1757: cst_cg_list_temp CGS,
1758: mtl_interorg_parameters MIP,
1759: mtl_system_items MSI_TO,

Line 1855: FROM mtl_material_transactions MMT,

1851: )
1852: ),
1853: NVL(MMT.intransit_account, MIP.intransit_inv_account),
1854: RT.shipment_line_id
1855: FROM mtl_material_transactions MMT,
1856: cst_item_list_temp ITEMS,
1857: cst_cg_list_temp CGS,
1858: mtl_interorg_parameters MIP,
1859: mtl_system_items MSI_FROM,

Line 1956: FROM mtl_material_transactions MMT,

1952: )
1953: ),
1954: NVL(MMT.intransit_account,MIP.intransit_inv_account),
1955: RSL.shipment_line_id
1956: FROM mtl_material_transactions MMT,
1957: cst_item_list_temp ITEMS,
1958: cst_cg_list_temp CGS,
1959: mtl_interorg_parameters MIP,
1960: mtl_system_items MSI_TO,

Line 2057: FROM mtl_material_transactions MMT,

2053: )
2054: ),
2055: NVL(MMT.intransit_account, MIP.intransit_inv_account),
2056: RT.shipment_line_id
2057: FROM mtl_material_transactions MMT,
2058: cst_item_list_temp ITEMS,
2059: cst_cg_list_temp CGS,
2060: mtl_interorg_parameters MIP,
2061: mtl_system_items MSI_FROM,

Line 2166: mtl_material_transactions MMT,

2162: cst_item_list_temp ITEMS,
2163: cst_cg_list_temp CGS,
2164: mtl_parameters MP,
2165: mtl_interorg_parameters MIP,
2166: mtl_material_transactions MMT,
2167: rcv_shipment_lines RSL,
2168: mtl_system_items MSI_FROM
2169: WHERE MS.to_organization_id = p_organization_id
2170: /* AND MS.intransit_owning_org_id = p_organization_id */ /* Bug 5664736 */

Line 2259: FROM mtl_material_transactions MMT,

2255: MMT.primary_quantity
2256: )
2257: ),
2258: NVL(MMT.intransit_account,MIP.intransit_inv_account)
2259: FROM mtl_material_transactions MMT,
2260: cst_item_list_temp ITEMS,
2261: cst_cg_list_temp CGS,
2262: mtl_interorg_parameters MIP,
2263: mtl_system_items MSI_TO

Line 2347: FROM mtl_material_transactions MMT,

2343: )
2344: )
2345: ),
2346: NVL(MMT.intransit_account, MIP.intransit_inv_account)
2347: FROM mtl_material_transactions MMT,
2348: cst_item_list_temp ITEMS,
2349: cst_cg_list_temp CGS,
2350: mtl_interorg_parameters MIP,
2351: mtl_system_items MSI_FROM

Line 2443: FROM mtl_material_transactions MMT,

2439: MMT.primary_quantity
2440: )
2441: ),
2442: NVL(MMT.intransit_account,MIP.intransit_inv_account)
2443: FROM mtl_material_transactions MMT,
2444: cst_item_list_temp ITEMS,
2445: cst_cg_list_temp CGS,
2446: mtl_interorg_parameters MIP,
2447: mtl_system_items MSI_TO,

Line 2540: FROM mtl_material_transactions MMT,

2536: )
2537: )
2538: ),
2539: NVL(MMT.intransit_account, MIP.intransit_inv_account)
2540: FROM mtl_material_transactions MMT,
2541: cst_item_list_temp ITEMS,
2542: cst_cg_list_temp CGS,
2543: mtl_interorg_parameters MIP,
2544: mtl_system_items MSI_FROM,

Line 2643: mtl_material_transactions MMT,

2639: cst_item_list_temp ITEMS,
2640: cst_cg_list_temp CGS,
2641: mtl_parameters MP,
2642: mtl_interorg_parameters MIP,
2643: mtl_material_transactions MMT,
2644: rcv_shipment_lines RSL,
2645: mtl_system_items MSI_FROM
2646: WHERE MS.from_organization_id = p_organization_id
2647: /* AND MS.intransit_owning_org_id = p_organization_id */ /* Bug 5664736 */

Line 2739: FROM mtl_material_transactions MMT,

2735: MMT.primary_quantity
2736: )
2737: ),
2738: NVL(MMT.intransit_account,MIP.intransit_inv_account)
2739: FROM mtl_material_transactions MMT,
2740: cst_item_list_temp ITEMS,
2741: cst_cg_list_temp CGS,
2742: mtl_interorg_parameters MIP,
2743: mtl_system_items MSI_TO

Line 2831: FROM mtl_material_transactions MMT,

2827: )
2828: )
2829: ),
2830: NVL(MMT.intransit_account, MIP.intransit_inv_account)
2831: FROM mtl_material_transactions MMT,
2832: cst_item_list_temp ITEMS,
2833: cst_cg_list_temp CGS,
2834: mtl_interorg_parameters MIP,
2835: mtl_system_items MSI_FROM

Line 2927: FROM mtl_material_transactions MMT,

2923: MMT.primary_quantity
2924: )
2925: ),
2926: NVL(MMT.intransit_account,MIP.intransit_inv_account)
2927: FROM mtl_material_transactions MMT,
2928: cst_item_list_temp ITEMS,
2929: cst_cg_list_temp CGS,
2930: mtl_interorg_parameters MIP,
2931: mtl_system_items MSI_TO,

Line 3024: FROM mtl_material_transactions MMT,

3020: )
3021: )
3022: ),
3023: NVL(MMT.intransit_account, MIP.intransit_inv_account)
3024: FROM mtl_material_transactions MMT,
3025: cst_item_list_temp ITEMS,
3026: cst_cg_list_temp CGS,
3027: mtl_interorg_parameters MIP,
3028: mtl_system_items MSI_FROM,

Line 3490: mtl_material_transactions mmt

3486: SUM(DECODE(mcacd.cost_element_id,5,nvl(mcacd.actual_cost,0),0))
3487: OVER (PARTITION BY MMT.transaction_id) overhead_cost,
3488: NVL(MCACD.creation_date,MMT.creation_date) txn_date
3489: FROM MTL_CST_ACTUAL_COST_DETAILS MCACD,
3490: mtl_material_transactions mmt
3491: WHERE MCACD.ORGANIZATION_ID(+) = c_organization_id
3492: AND MCACD.inventory_item_id(+) = c_inventory_item_id
3493: AND MMT.transaction_date > c_valuation_date
3494: AND mmt.transaction_action_id NOT IN (5,30,40,41,42,43,50,51,52,15,22,11,17,10,13,9,14,7,26,36,25,56,57)

Line 4286: FROM mtl_material_transactions MMT,

4282: MIN(MMT.transaction_date) transaction_date,
4283: MMT.transfer_organization_id,
4284: MMT.inventory_item_id,
4285: MMT.transfer_cost_group_id
4286: FROM mtl_material_transactions MMT,
4287: mtl_interorg_parameters MIP
4288: WHERE MMT.transaction_action_id = 21
4289: AND MIP.from_organization_id = MMT.organization_id
4290: AND MIP.to_organization_id = MMT.transfer_organization_id

Line 4300: mtl_material_transactions MMT,

4296: BY MMT.transfer_organization_id,
4297: MMT.inventory_item_id,
4298: MMT.transfer_cost_group_id
4299: ) MINDATE,
4300: mtl_material_transactions MMT,
4301: mtl_interorg_parameters MIP
4302: WHERE MMT.transfer_organization_id = MINDATE.transfer_organization_id
4303: AND MMT.inventory_item_id = MINDATE.inventory_item_id
4304: AND MMT.transfer_cost_group_id = MINDATE.transfer_cost_group_id

Line 4320: SELECT /+ leading(MINDATE) use_nl(MMT) index(MMT,MTL_MATERIAL_TRANSACTIONS_N1) /

4316: MMT.inventory_item_id,
4317: MMT.transfer_cost_group_id
4318: ) TFR_TXN,
4319: (
4320: SELECT /*+ leading(MINDATE) use_nl(MMT) index(MMT,MTL_MATERIAL_TRANSACTIONS_N1) */
4321: MIN(MMT.transaction_id) transaction_id,
4322: MMT.transaction_date,
4323: MMT.organization_id,
4324: MMT.inventory_item_id,

Line 4379: FROM mtl_material_transactions MMT,

4375: 'N'
4376: ),
4377: 'N'
4378: ) restrict_mcacd
4379: FROM mtl_material_transactions MMT,
4380: (
4381: SELECT /*+ no_merge */ MIN(MMT.transaction_date) transaction_date,
4382: MMT.organization_id,
4383: MMT.inventory_item_id,

Line 4400: FROM mtl_material_transactions MMT

4396: MMT.cost_group_id
4397: ),
4398: MMT.cost_group_id
4399: ) cost_group_id
4400: FROM mtl_material_transactions MMT
4401: WHERE MMT.transaction_action_id <> 30
4402: AND MMT.prior_cost IS NOT NULL
4403: AND MMT.costed_flag IS NULL
4404: -- Ignore consigned transactions