DBA Data[Home] [Help]

APPS.CST_INVENTORY_PVT dependencies on MTL_SYSTEM_ITEMS

Line 132: mtl_system_items_kfv MSI,

128: SELECT MSI.inventory_item_id,
129: MIC.category_id,
130: CIC.cost_type_id
131: FROM mtl_item_categories MIC,
132: mtl_system_items_kfv MSI,
133: cst_item_costs CIC
134: -- cst_item_costs CIC1,
135: -- cst_item_costs CIC2
136: WHERE MIC.category_set_id = p_category_set_id

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 224: mtl_system_items_kfv MSI,

220: MIC.category_id,
221: CIC.cost_type_id
222: FROM mtl_item_categories MIC,
223: mtl_categories_kfv MC,
224: mtl_system_items_kfv MSI,
225: cst_item_costs CIC
226: -- cst_item_costs CIC1,
227: -- cst_item_costs CIC2
228: WHERE MC.concatenated_segments

Line 275: mtl_system_items_kfv MSI,

271: MIC.category_id,
272: CIC.cost_type_id
273: FROM mtl_item_categories MIC,
274: mtl_categories_kfv MC,
275: mtl_system_items_kfv MSI,
276: cst_item_costs CIC,
277: cst_item_costs CIC1,
278: cst_item_costs CIC2
279: WHERE MC.concatenated_segments

Line 338: mtl_system_items_kfv MSI

334: MIC.category_id,
335: l_def_cost_type_id
336: FROM mtl_item_categories MIC,
337: mtl_categories_kfv MC,
338: mtl_system_items_kfv MSI
339: WHERE MC.concatenated_segments
340: BETWEEN NVL(p_category_from,MC.concatenated_segments)
341: AND NVL(p_category_to,MC.concatenated_segments)
342: AND MC.structure_id = (SELECT structure_id FROM mtl_category_sets WHERE category_set_id = p_category_set_id)

Line 1156: mtl_system_items MSI_FROM

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

Line 1256: mtl_system_items MSI_TO,

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,
1257: rcv_shipment_headers RSH,
1258: rcv_shipment_lines RSL
1259: WHERE MMT.transfer_organization_id = p_organization_id
1260: AND MMT.transaction_action_id = 21

Line 1352: mtl_system_items MSI_FROM,

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,
1353: rcv_transactions RT
1354: WHERE MMT.organization_id = p_organization_id
1355: AND MMT.transaction_action_id = 12
1356: AND MMT.costed_flag IN ('N', 'E')

Line 1453: mtl_system_items MSI_TO,

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,
1454: rcv_shipment_headers RSH,
1455: rcv_shipment_lines RSL
1456: WHERE MMT.transfer_organization_id = p_organization_id
1457: AND MMT.transaction_action_id = 21

Line 1554: mtl_system_items MSI_FROM,

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,
1555: rcv_transactions RT
1556: WHERE MMT.organization_id = p_organization_id
1557: AND MMT.transaction_action_id = 12
1558: AND MMT.costed_flag IS NULL

Line 1656: mtl_system_items MSI_FROM

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

Line 1759: mtl_system_items MSI_TO,

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,
1760: rcv_shipment_headers RSH,
1761: rcv_shipment_lines RSL
1762: WHERE MMT.organization_id = p_organization_id
1763: AND MMT.transaction_action_id = 21

Line 1859: mtl_system_items MSI_FROM,

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,
1860: rcv_transactions RT
1861: WHERE MMT.transfer_organization_id = p_organization_id
1862: AND MMT.transaction_action_id = 12
1863: AND MMT.costed_flag IN ('N', 'E')

Line 1960: mtl_system_items MSI_TO,

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,
1961: rcv_shipment_headers RSH,
1962: rcv_shipment_lines RSL
1963: WHERE MMT.organization_id = p_organization_id
1964: AND MMT.transaction_action_id = 21

Line 2061: mtl_system_items MSI_FROM,

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,
2062: rcv_transactions RT
2063: WHERE MMT.transfer_organization_id = p_organization_id
2064: AND MMT.transaction_action_id = 12
2065: AND MMT.costed_flag IS NULL

Line 2168: mtl_system_items MSI_FROM

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

Line 2263: mtl_system_items MSI_TO

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
2264: WHERE MMT.transfer_organization_id = p_organization_id
2265: AND MMT.transaction_action_id = 21
2266: AND MMT.costed_flag IN ('N','E')
2267: AND MMT.inventory_item_id = ITEMS.inventory_item_id

Line 2351: mtl_system_items MSI_FROM

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

Line 2447: mtl_system_items MSI_TO,

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,
2448: mtl_transaction_types MTT
2449: WHERE MMT.transfer_organization_id = p_organization_id
2450: AND MMT.transaction_action_id = 21
2451: AND MMT.costed_flag IS NULL

Line 2544: mtl_system_items MSI_FROM,

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,
2545: mtl_transaction_types MTT
2546: WHERE MMT.organization_id = p_organization_id
2547: AND MMT.transaction_action_id = 12
2548: AND MMT.costed_flag IS NULL

Line 2645: mtl_system_items MSI_FROM

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

Line 2743: mtl_system_items MSI_TO

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
2744: WHERE MMT.organization_id = p_organization_id
2745: AND MMT.transaction_action_id = 21
2746: AND MMT.costed_flag IN ('N','E')
2747: AND MMT.inventory_item_id = ITEMS.inventory_item_id

Line 2835: mtl_system_items MSI_FROM

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
2836: WHERE MMT.transfer_organization_id = p_organization_id
2837: AND MMT.transaction_action_id = 12
2838: AND MMT.costed_flag IN ('N', 'E')
2839: AND MMT.inventory_item_id = ITEMS.inventory_item_id

Line 2931: mtl_system_items MSI_TO,

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,
2932: mtl_transaction_types MTT
2933: WHERE MMT.organization_id = p_organization_id
2934: AND MMT.transaction_action_id = 21
2935: AND MMT.costed_flag IS NULL

Line 3028: mtl_system_items MSI_FROM,

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,
3029: mtl_transaction_types MTT
3030: WHERE MMT.transfer_organization_id = p_organization_id
3031: AND MMT.transaction_action_id = 12
3032: AND MMT.costed_flag IS NULL