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 2173: mtl_secondary_inventories msi

2169: mtl_related_items mri,
2170: mtl_parameters mp,
2171: mtl_system_items_b msib,
2172: mtl_item_sub_inventories misi,
2173: mtl_secondary_inventories msi
2174: where cri.level_id like l_level_id || '%'
2175: and mp.organization_id = cri.organization_id
2176: and mri.organization_id = mp.master_organization_id
2177: and mri.inventory_item_id = cri.inventory_item_id

Line 2223: mtl_secondary_inventories msi,

2219: sysdate
2220: from mtl_parameters mp,
2221: mtl_system_items_b msib,
2222: mtl_item_sub_inventories misi,
2223: mtl_secondary_inventories msi,
2224: csp_supply_chain csc
2225: where mp.organization_id = csc.source_organization_id
2226: and misi.organization_id (+) = csc.source_organization_id
2227: and misi.inventory_item_id (+) = csc.inventory_item_id

Line 2401: mtl_secondary_inventories msi,

2397: sysdate
2398: from mtl_parameters mp,
2399: mtl_system_items_b msib,
2400: mtl_item_sub_inventories misi,
2401: mtl_secondary_inventories msi,
2402: mtl_material_transactions mmt,
2403: mtl_interorg_ship_methods mism
2404: where mp.organization_id = mmt.organization_id
2405: and misi.organization_id (+) = mmt.organization_id

Line 2467: mtl_secondary_inventories msi,

2463: sysdate
2464: from mtl_parameters mp,
2465: mtl_system_items_b msib,
2466: mtl_item_sub_inventories misi,
2467: mtl_secondary_inventories msi,
2468: csp_supply_chain csc,
2469: mtl_interorg_ship_methods mism
2470: where mp.organization_id = csc.source_organization_id
2471: and misi.organization_id (+) = csc.source_organization_id