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.

[Home] [Help]

APPS.CST_INVENTORY_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 863: FROM mtl_material_transactions MMT,

859: DECODE(p_qty_by_revision, 1, MMT.revision, NULL),
860: MMT.transaction_source_type_id,
861: CILT.category_id,
862: CILT.cost_type_id
863: FROM mtl_material_transactions MMT,
864: cst_item_list_temp CILT,
865: cst_cg_list_temp CCLT,
866: cst_sub_list_temp CSLT
867: WHERE MMT.organization_id = p_organization_id

Line 948: FROM mtl_material_transactions MMT,

944: DECODE(p_qty_by_revision, 1, MMT.revision, NULL),
945: MMT.transaction_source_type_id,
946: CILT.category_id,
947: CILT.cost_type_id
948: FROM mtl_material_transactions MMT,
949: cst_item_list_temp CILT
950: WHERE MMT.organization_id = p_organization_id
951: AND CILT.inventory_item_id = MMT.inventory_item_id
952: AND MMT.costed_flag IS NULL

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

1133: l_stmt_num := 5;
1134:
1135: DECLARE
1136: CURSOR c IS
1137: SELECT /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */ 1
1138: FROM mtl_material_transactions MMT
1139: WHERE mmt.costed_flag IN ('N','E')
1140: AND ( mmt.organization_id = p_organization_id
1141: OR mmt.transfer_organization_id = p_organization_id)

Line 1138: FROM mtl_material_transactions MMT

1134:
1135: DECLARE
1136: CURSOR c IS
1137: SELECT /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */ 1
1138: FROM mtl_material_transactions MMT
1139: WHERE mmt.costed_flag IN ('N','E')
1140: AND ( mmt.organization_id = p_organization_id
1141: OR mmt.transfer_organization_id = p_organization_id)
1142: /* Bug 9764385: Modified the query to include Logical Intransit transactions */

Line 1230: mtl_material_transactions MMT,

1226: cst_item_list_temp ITEMS,
1227: cst_cg_list_temp CGS,
1228: mtl_parameters MP,
1229: mtl_interorg_parameters MIP,
1230: mtl_material_transactions MMT,
1231: rcv_shipment_lines RSL,
1232: mtl_system_items MSI_FROM
1233: WHERE MS.to_organization_id = p_organization_id
1234: /* AND MS.intransit_owning_org_id = p_organization_id */ /* Bug 5664736 */

Line 1330: FROM mtl_material_transactions MMT,

1326: )
1327: ),
1328: NVL(MMT.intransit_account,MIP.intransit_inv_account),
1329: RSL.shipment_line_id
1330: FROM mtl_material_transactions MMT,
1331: cst_item_list_temp ITEMS,
1332: cst_cg_list_temp CGS,
1333: mtl_interorg_parameters MIP,
1334: mtl_system_items MSI_TO,

Line 1423: FROM mtl_material_transactions MMT,

1419: )
1420: ),
1421: NVL(MMT.intransit_account, MIP.intransit_inv_account),
1422: RT.shipment_line_id
1423: FROM mtl_material_transactions MMT,
1424: cst_item_list_temp ITEMS,
1425: cst_cg_list_temp CGS,
1426: mtl_interorg_parameters MIP,
1427: mtl_system_items MSI_FROM,

Line 1521: FROM mtl_material_transactions MMT,

1517: )
1518: ),
1519: NVL(MMT.intransit_account,MIP.intransit_inv_account),
1520: RSL.shipment_line_id
1521: FROM mtl_material_transactions MMT,
1522: cst_item_list_temp ITEMS,
1523: cst_cg_list_temp CGS,
1524: mtl_interorg_parameters MIP,
1525: mtl_system_items MSI_TO,

Line 1538: FROM mtl_material_transactions

1534: FROM mtl_parameters
1535: WHERE process_enabled_flag = 'Y')
1536: OR
1537: EXISTS (SELECT 1
1538: FROM mtl_material_transactions
1539: WHERE parent_transaction_id = mmt.transaction_id
1540: AND transaction_action_id = 15
1541: AND organization_id = p_organization_id
1542: AND costed_flag IS NULL))

Line 1631: FROM mtl_material_transactions MMT,

1627: )
1628: ),
1629: NVL(MMT.intransit_account, MIP.intransit_inv_account),
1630: RT.shipment_line_id
1631: FROM mtl_material_transactions MMT,
1632: cst_item_list_temp ITEMS,
1633: cst_cg_list_temp CGS,
1634: mtl_interorg_parameters MIP,
1635: mtl_system_items MSI_FROM,

Line 1734: mtl_material_transactions MMT,

1730: cst_item_list_temp ITEMS,
1731: cst_cg_list_temp CGS,
1732: mtl_parameters MP,
1733: mtl_interorg_parameters MIP,
1734: mtl_material_transactions MMT,
1735: rcv_shipment_lines RSL,
1736: mtl_system_items MSI_FROM
1737: WHERE MS.from_organization_id = p_organization_id
1738: /* AND MS.intransit_owning_org_id = p_organization_id */ /* Bug 5664736 */

Line 1836: FROM mtl_material_transactions MMT,

1832: )
1833: ),
1834: NVL(MMT.intransit_account,MIP.intransit_inv_account),
1835: RSL.shipment_line_id
1836: FROM mtl_material_transactions MMT,
1837: cst_item_list_temp ITEMS,
1838: cst_cg_list_temp CGS,
1839: mtl_interorg_parameters MIP,
1840: mtl_system_items MSI_TO,

Line 1934: FROM mtl_material_transactions MMT,

1930: )
1931: ),
1932: NVL(MMT.intransit_account, MIP.intransit_inv_account),
1933: RT.shipment_line_id
1934: FROM mtl_material_transactions MMT,
1935: cst_item_list_temp ITEMS,
1936: cst_cg_list_temp CGS,
1937: mtl_interorg_parameters MIP,
1938: mtl_system_items MSI_FROM,

Line 2032: FROM mtl_material_transactions MMT,

2028: )
2029: ),
2030: NVL(MMT.intransit_account,MIP.intransit_inv_account),
2031: RSL.shipment_line_id
2032: FROM mtl_material_transactions MMT,
2033: cst_item_list_temp ITEMS,
2034: cst_cg_list_temp CGS,
2035: mtl_interorg_parameters MIP,
2036: mtl_system_items MSI_TO,

Line 2130: FROM mtl_material_transactions MMT,

2126: )
2127: ),
2128: NVL(MMT.intransit_account, MIP.intransit_inv_account),
2129: RT.shipment_line_id
2130: FROM mtl_material_transactions MMT,
2131: cst_item_list_temp ITEMS,
2132: cst_cg_list_temp CGS,
2133: mtl_interorg_parameters MIP,
2134: mtl_system_items MSI_FROM,

Line 2147: FROM mtl_material_transactions

2143: FROM mtl_parameters
2144: WHERE process_enabled_flag = 'Y')
2145: OR
2146: EXISTS (SELECT 1
2147: FROM mtl_material_transactions
2148: WHERE parent_transaction_id = mmt.transaction_id
2149: AND transaction_action_id = 22
2150: AND organization_id = mmt.transfer_organization_id
2151: AND costed_flag IS NULL))

Line 2251: mtl_material_transactions MMT,

2247: cst_item_list_temp ITEMS,
2248: cst_cg_list_temp CGS,
2249: mtl_parameters MP,
2250: mtl_interorg_parameters MIP,
2251: mtl_material_transactions MMT,
2252: rcv_shipment_lines RSL,
2253: mtl_system_items MSI_FROM
2254: WHERE MS.to_organization_id = p_organization_id
2255: /* AND MS.intransit_owning_org_id = p_organization_id */ /* Bug 5664736 */

Line 2346: FROM mtl_material_transactions MMT,

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

Line 2431: FROM mtl_material_transactions MMT,

2427: )
2428: )
2429: ),
2430: NVL(MMT.intransit_account, MIP.intransit_inv_account)
2431: FROM mtl_material_transactions MMT,
2432: cst_item_list_temp ITEMS,
2433: cst_cg_list_temp CGS,
2434: mtl_interorg_parameters MIP,
2435: mtl_system_items MSI_FROM

Line 2524: FROM mtl_material_transactions MMT,

2520: MMT.primary_quantity
2521: )
2522: ),
2523: NVL(MMT.intransit_account,MIP.intransit_inv_account)
2524: FROM mtl_material_transactions MMT,
2525: cst_item_list_temp ITEMS,
2526: cst_cg_list_temp CGS,
2527: mtl_interorg_parameters MIP,
2528: mtl_system_items MSI_TO,

Line 2540: FROM mtl_material_transactions

2536: FROM mtl_parameters
2537: WHERE process_enabled_flag = 'Y')
2538: OR
2539: EXISTS (SELECT 1
2540: FROM mtl_material_transactions
2541: WHERE parent_transaction_id = mmt.transaction_id
2542: AND transaction_action_id = 15
2543: AND organization_id = p_organization_id
2544: AND costed_flag IS NULL))

Line 2630: FROM mtl_material_transactions MMT,

2626: )
2627: )
2628: ),
2629: NVL(MMT.intransit_account, MIP.intransit_inv_account)
2630: FROM mtl_material_transactions MMT,
2631: cst_item_list_temp ITEMS,
2632: cst_cg_list_temp CGS,
2633: mtl_interorg_parameters MIP,
2634: mtl_system_items MSI_FROM,

Line 2732: mtl_material_transactions MMT,

2728: cst_item_list_temp ITEMS,
2729: cst_cg_list_temp CGS,
2730: mtl_parameters MP,
2731: mtl_interorg_parameters MIP,
2732: mtl_material_transactions MMT,
2733: rcv_shipment_lines RSL,
2734: mtl_system_items MSI_FROM
2735: WHERE MS.from_organization_id = p_organization_id
2736: /* AND MS.intransit_owning_org_id = p_organization_id */ /* Bug 5664736 */

Line 2829: FROM mtl_material_transactions MMT,

2825: MMT.primary_quantity
2826: )
2827: ),
2828: NVL(MMT.intransit_account,MIP.intransit_inv_account)
2829: FROM mtl_material_transactions MMT,
2830: cst_item_list_temp ITEMS,
2831: cst_cg_list_temp CGS,
2832: mtl_interorg_parameters MIP,
2833: mtl_system_items MSI_TO

Line 2919: FROM mtl_material_transactions MMT,

2915: )
2916: )
2917: ),
2918: NVL(MMT.intransit_account, MIP.intransit_inv_account)
2919: FROM mtl_material_transactions MMT,
2920: cst_item_list_temp ITEMS,
2921: cst_cg_list_temp CGS,
2922: mtl_interorg_parameters MIP,
2923: mtl_system_items MSI_FROM

Line 3013: FROM mtl_material_transactions MMT,

3009: MMT.primary_quantity
3010: )
3011: ),
3012: NVL(MMT.intransit_account,MIP.intransit_inv_account)
3013: FROM mtl_material_transactions MMT,
3014: cst_item_list_temp ITEMS,
3015: cst_cg_list_temp CGS,
3016: mtl_interorg_parameters MIP,
3017: mtl_system_items MSI_TO,

Line 3107: FROM mtl_material_transactions MMT,

3103: )
3104: )
3105: ),
3106: NVL(MMT.intransit_account, MIP.intransit_inv_account)
3107: FROM mtl_material_transactions MMT,
3108: cst_item_list_temp ITEMS,
3109: cst_cg_list_temp CGS,
3110: mtl_interorg_parameters MIP,
3111: mtl_system_items MSI_FROM,

Line 3124: FROM mtl_material_transactions

3120: FROM mtl_parameters
3121: WHERE process_enabled_flag = 'Y')
3122: OR
3123: EXISTS (SELECT 1
3124: FROM mtl_material_transactions
3125: WHERE parent_transaction_id = mmt.transaction_id
3126: AND transaction_action_id = 22
3127: AND organization_id = mmt.transfer_organization_id
3128: AND costed_flag IS NULL))

Line 3590: mtl_material_transactions mmt

3586: SUM(DECODE(mcacd.cost_element_id,5,nvl(mcacd.actual_cost,0),0))
3587: OVER (PARTITION BY MMT.transaction_id) overhead_cost,
3588: NVL(MCACD.creation_date,MMT.creation_date) txn_date
3589: FROM MTL_CST_ACTUAL_COST_DETAILS MCACD,
3590: mtl_material_transactions mmt
3591: WHERE MCACD.ORGANIZATION_ID(+) = p_organization_id
3592: AND MCACD.inventory_item_id(+) = p_inventory_item_id
3593: AND MMT.transaction_date > p_valuation_date
3594: AND mmt.transaction_action_id NOT IN (5,30,40,41,42,43,50,51,52,/* 9764385: 15,22,*/11,17,10,13,9,14,7,26,36,25,56,57)

Line 4471: MTL_MATERIAL_TRANSACTIONS MMT,

4467: to_organization_id
4468: from mtl_interorg_parameters
4469: where from_organization_id = p_organization_id
4470: or to_organization_id = p_organization_id) MIP,
4471: MTL_MATERIAL_TRANSACTIONS MMT,
4472: MTL_CST_ACTUAL_COST_DETAILS MCACD
4473: where ( ( MMT.creation_date <= NVL(NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,
4474: CST_Inventory_PVT.g_run_onhand_date),
4475: MMT.creation_date)

Line 4509: from MTL_MATERIAL_TRANSACTIONS MMT,

4505: MMT.creation_date,
4506: MCACD.layer_id,
4507: MMT.inventory_item_id,
4508: MCACD.organization_id
4509: from MTL_MATERIAL_TRANSACTIONS MMT,
4510: MTL_CST_ACTUAL_COST_DETAILS MCACD
4511: where MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_onhand_date,MMT.creation_date)
4512: AND MMT.costed_flag is null
4513: AND MMT.transaction_action_id not in (5,30,40,41,42,43,50,51,52,11,17,10,13,9,14,7,26,36,25,56,57)