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 2403: mtl_interorg_ship_methods mism

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

Line 2469: mtl_interorg_ship_methods mism

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