DBA Data[Home] [Help]

APPS.CSP_AUTO_ASLMSL_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 572: mtl_secondary_inventories msi,

568: cst_item_costs cic,
569: mtl_parameters mp,
570: mtl_system_items_b msib,
571: mtl_item_sub_inventories misi,
572: mtl_secondary_inventories msi,
573: mtl_interorg_ship_methods mism1,
574: mtl_interorg_ship_methods mism2,
575: mtl_interorg_ship_methods mism3,
576: mtl_interorg_ship_methods mism4

Line 2193: mtl_secondary_inventories msi

2189: mtl_related_items mri,
2190: mtl_parameters mp,
2191: mtl_system_items_b msib,
2192: mtl_item_sub_inventories misi,
2193: mtl_secondary_inventories msi
2194: where cri.level_id like l_level_id || '%'
2195: and mp.organization_id = cri.organization_id
2196: and mri.organization_id = mp.master_organization_id
2197: and mri.inventory_item_id = cri.inventory_item_id

Line 2243: mtl_secondary_inventories msi,

2239: sysdate
2240: from mtl_parameters mp,
2241: mtl_system_items_b msib,
2242: mtl_item_sub_inventories misi,
2243: mtl_secondary_inventories msi,
2244: csp_supply_chain csc
2245: where mp.organization_id = csc.source_organization_id
2246: and misi.organization_id (+) = csc.source_organization_id
2247: and misi.inventory_item_id (+) = csc.inventory_item_id

Line 2421: mtl_secondary_inventories msi,

2417: sysdate
2418: from mtl_parameters mp,
2419: mtl_system_items_b msib,
2420: mtl_item_sub_inventories misi,
2421: mtl_secondary_inventories msi,
2422: mtl_material_transactions mmt,
2423: mtl_interorg_ship_methods mism
2424: where mp.organization_id = mmt.organization_id
2425: and misi.organization_id (+) = mmt.organization_id

Line 2487: mtl_secondary_inventories msi,

2483: sysdate
2484: from mtl_parameters mp,
2485: mtl_system_items_b msib,
2486: mtl_item_sub_inventories misi,
2487: mtl_secondary_inventories msi,
2488: csp_supply_chain csc,
2489: mtl_interorg_ship_methods mism
2490: where mp.organization_id = csc.source_organization_id
2491: and misi.organization_id (+) = csc.source_organization_id