DBA Data[Home] [Help]

APPS.CSP_AUTO_ASLMSL_PVT dependencies on MTL_INTERORG_SHIP_METHODS

Line 573: mtl_interorg_ship_methods mism1,

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
577: where cpp.level_id like p_level_id || '%'

Line 574: mtl_interorg_ship_methods mism2,

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
577: where cpp.level_id like p_level_id || '%'
578: and cpp.node_type in ('ORGANIZATION_WH','SUBINVENTORY')

Line 575: mtl_interorg_ship_methods mism3,

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
577: where cpp.level_id like p_level_id || '%'
578: and cpp.node_type in ('ORGANIZATION_WH','SUBINVENTORY')
579: and cpp.recommend_method in ('USAGE','USAGE_PNORM','USAGE_TNORM','PNORM','TNORM')

Line 576: mtl_interorg_ship_methods mism4

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
577: where cpp.level_id like p_level_id || '%'
578: and cpp.node_type in ('ORGANIZATION_WH','SUBINVENTORY')
579: and cpp.recommend_method in ('USAGE','USAGE_PNORM','USAGE_TNORM','PNORM','TNORM')
580: and cuh.organization_id = cpp.organization_id

Line 2423: mtl_interorg_ship_methods mism

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
2426: and misi.inventory_item_id (+) = mmt.inventory_item_id
2427: and misi.secondary_inventory (+) = mmt.subinventory_code

Line 2489: mtl_interorg_ship_methods mism

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
2492: and misi.inventory_item_id (+) = csc.inventory_item_id
2493: and misi.secondary_inventory (+) = csc.source_subinventory