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_SYSTEM_ITEMS

Line 174: mtl_system_items_kfv MSI,

170: SELECT MSI.inventory_item_id,
171: MIC.category_id,
172: CIC.cost_type_id
173: FROM mtl_item_categories MIC,
174: mtl_system_items_kfv MSI,
175: cst_item_costs CIC
176: -- cst_item_costs CIC1,
177: -- cst_item_costs CIC2
178: WHERE MIC.category_set_id = p_category_set_id

Line 215: mtl_system_items_kfv MSI,

211: SELECT MSI.inventory_item_id,
212: MIC.category_id,
213: CIC.cost_type_id
214: FROM mtl_item_categories MIC,
215: mtl_system_items_kfv MSI,
216: cst_item_costs CIC,
217: cst_item_costs CIC1,
218: cst_item_costs CIC2
219: WHERE MIC.category_set_id = p_category_set_id

Line 262: mtl_system_items_kfv MSI,

258: MIC.category_id,
259: CIC.cost_type_id
260: FROM mtl_item_categories MIC,
261: mtl_categories_kfv MC,
262: mtl_system_items_kfv MSI,
263: cst_item_costs CIC
264: -- cst_item_costs CIC1,
265: -- cst_item_costs CIC2
266: WHERE MC.concatenated_segments

Line 313: mtl_system_items_kfv MSI,

309: MIC.category_id,
310: CIC.cost_type_id
311: FROM mtl_item_categories MIC,
312: mtl_categories_kfv MC,
313: mtl_system_items_kfv MSI,
314: cst_item_costs CIC,
315: cst_item_costs CIC1,
316: cst_item_costs CIC2
317: WHERE MC.concatenated_segments

Line 376: mtl_system_items_kfv MSI

372: MIC.category_id,
373: l_def_cost_type_id
374: FROM mtl_item_categories MIC,
375: mtl_categories_kfv MC,
376: mtl_system_items_kfv MSI
377: WHERE MC.concatenated_segments
378: BETWEEN NVL(p_category_from,MC.concatenated_segments)
379: AND NVL(p_category_to,MC.concatenated_segments)
380: AND MC.structure_id = (SELECT structure_id FROM mtl_category_sets WHERE category_set_id = p_category_set_id)

Line 1232: mtl_system_items MSI_FROM

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 */
1235: AND MS.intransit_owning_org_id = DECODE(NVL(p_own,-1),1,p_organization_id,MS.intransit_owning_org_id)
1236: AND MS.item_id = ITEMS.inventory_item_id

Line 1334: mtl_system_items MSI_TO,

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,
1335: rcv_shipment_headers RSH,
1336: rcv_shipment_lines RSL
1337: WHERE Decode(MMT.transaction_action_id, 21, MMT.transfer_organization_id, 15, MMT.organization_id) = p_organization_id
1338: AND MMT.transaction_action_id IN (21, 15)

Line 1427: mtl_system_items MSI_FROM,

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,
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')

Line 1525: mtl_system_items MSI_TO,

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,
1526: rcv_shipment_headers RSH,
1527: rcv_shipment_lines RSL
1528: WHERE MMT.transfer_organization_id = p_organization_id
1529: AND MMT.transaction_action_id = 21

Line 1635: mtl_system_items MSI_FROM,

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,
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

Line 1736: mtl_system_items MSI_FROM

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 */
1739: AND MS.intransit_owning_org_id = DECODE(NVL(p_own,-1),1,p_organization_id,MS.intransit_owning_org_id)
1740: AND MS.item_id = ITEMS.inventory_item_id

Line 1840: mtl_system_items MSI_TO,

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,
1841: rcv_shipment_headers RSH,
1842: rcv_shipment_lines RSL
1843: WHERE MMT.organization_id = p_organization_id
1844: AND MMT.transaction_action_id = 21

Line 1938: mtl_system_items MSI_FROM,

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,
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')

Line 2036: mtl_system_items MSI_TO,

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,
2037: rcv_shipment_headers RSH,
2038: rcv_shipment_lines RSL
2039: WHERE MMT.organization_id = p_organization_id
2040: AND MMT.transaction_action_id = 21

Line 2134: mtl_system_items MSI_FROM,

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,
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

Line 2253: mtl_system_items MSI_FROM

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 */
2256: AND MS.intransit_owning_org_id = DECODE(NVL(p_own,-1),1,p_organization_id,MS.intransit_owning_org_id)
2257: AND MS.item_id = ITEMS.inventory_item_id

Line 2350: mtl_system_items MSI_TO

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
2351: WHERE Decode(MMT.transaction_action_id, 21, MMT.transfer_organization_id, 15, MMT.organization_id) = p_organization_id
2352: AND MMT.transaction_action_id IN (21, 15)
2353: AND MMT.costed_flag IN ('N','E')
2354: AND MMT.inventory_item_id = ITEMS.inventory_item_id

Line 2435: mtl_system_items MSI_FROM

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
2436: WHERE MMT.organization_id = p_organization_id
2437: AND MMT.transaction_action_id = 12
2438: AND MMT.costed_flag IN ('N', 'E')
2439: AND MMT.inventory_item_id = ITEMS.inventory_item_id

Line 2528: mtl_system_items MSI_TO,

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,
2529: mtl_transaction_types MTT
2530: WHERE MMT.transfer_organization_id = p_organization_id
2531: AND MMT.transaction_action_id = 21
2532: AND MMT.costed_flag IS NULL

Line 2634: mtl_system_items MSI_FROM,

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,
2635: mtl_transaction_types MTT
2636: WHERE MMT.organization_id = p_organization_id
2637: AND MMT.transaction_action_id = 12
2638: AND MMT.costed_flag IS NULL

Line 2734: mtl_system_items MSI_FROM

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 */
2737: AND MS.intransit_owning_org_id = DECODE(NVL(p_own,-1),1,p_organization_id,MS.intransit_owning_org_id)
2738: AND MS.item_id = ITEMS.inventory_item_id

Line 2833: mtl_system_items MSI_TO

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
2834: WHERE MMT.organization_id = p_organization_id
2835: AND MMT.transaction_action_id = 21
2836: AND MMT.costed_flag IN ('N','E')
2837: AND MMT.inventory_item_id = ITEMS.inventory_item_id

Line 2923: mtl_system_items MSI_FROM

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
2924: WHERE Decode(MMT.transaction_action_id, 12, MMT.transfer_organization_id, 22, MMT.organization_id) = p_organization_id
2925: AND MMT.transaction_action_id IN (12,22)
2926: AND MMT.costed_flag IN ('N', 'E')
2927: AND MMT.inventory_item_id = ITEMS.inventory_item_id

Line 3017: mtl_system_items MSI_TO,

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,
3018: mtl_transaction_types MTT
3019: WHERE MMT.organization_id = p_organization_id
3020: AND MMT.transaction_action_id = 21
3021: AND MMT.costed_flag IS NULL

Line 3111: mtl_system_items MSI_FROM,

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,
3112: mtl_transaction_types MTT
3113: WHERE MMT.transfer_organization_id = p_organization_id
3114: AND MMT.transaction_action_id = 12
3115: AND MMT.costed_flag IS NULL