[Home] [Help]
399: Locator and Sub are fetched. (as part of bug 2314495)
400: ****************************************************************************/
401:
402: /* Changes for Bug #2810546
403: * a) Removed outer join between MFG_LOOKUPS and WMS_LICENSE_PLATE_NUMBERS since
404: * an LPN will always have a context associated
405: * b) Forked the code to fetch the dock door if the LPN context is "Loaded to Dock(9)"
406: * For this join between wms_license_plate_numbers, wms_shipping_transactions_temp
407: * and mtl_item_locations.
485: mtl_item_locations_kfv mlc ,
486: mtl_secondary_inventories msub,
487: mtl_item_locations_kfv milk,
488: mtl_system_items_vl msiv, /* Bug 5581528 */
489: mfg_lookups mlk
490: WHERE mmtt.transfer_lpn_id = p_parent_lpn_id
491: AND lpn.lpn_id = mmtt.transfer_lpn_id
492: AND lpn.organization_id = mp.organization_id
493: AND lpn.outermost_lpn_id = lpn3.lpn_id
556: mtl_secondary_inventories msub,
557: mtl_item_locations_kfv milk,
558: mtl_lot_numbers mln,
559: mtl_system_items_vl msiv, /* Bug 5581528 */
560: mfg_lookups mlk
561: WHERE mmtt.transfer_lpn_id = p_parent_lpn_id
562: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
563: AND lpn.lpn_id = mmtt.transfer_lpn_id
564: AND lpn.organization_id = mp.organization_id
625: mtl_item_locations milk,
626: mtl_item_locations milk2,
627: mtl_lot_numbers mln,
628: mtl_system_items_vl msiv, /* Bug 5581528 */
629: mfg_lookups mlk,
630: wms_shipping_transaction_temp wstt
631: WHERE wlc.parent_lpn_id = p_parent_lpn_id
632: AND lpn.lpn_id = wlc.parent_lpn_id
633: AND lpn.organization_id = mp.organization_id
688: cst_cost_groups ccg,
689: mtl_item_locations_kfv mlc ,
690: mtl_secondary_inventories msub,
691: mtl_item_locations_kfv milk,
692: mfg_lookups mlk,
693: wms_shipping_transaction_temp wstt,
694: mtl_item_locations_kfv milk2
695: WHERE wlc.parent_lpn_id = p_parent_lpn_id
696: AND lpn.lpn_id = wlc.parent_lpn_id
794: mtl_secondary_inventories msub,
795: mtl_item_locations milk,
796: mtl_lot_numbers mln,
797: mtl_system_items_vl msiv, /* Bug 5581528 */
798: mfg_lookups mlk
799: WHERE
800: lpn.lpn_id = wwlc.parent_lpn_id
801: AND lpn.organization_id = mp.organization_id
802: AND lpn.outermost_lpn_id = lpn3.lpn_id
895: cst_cost_groups ccg,
896: mtl_item_locations_kfv mlc ,
897: mtl_secondary_inventories msub,
898: mtl_item_locations_kfv milk,
899: mfg_lookups mlk
900: WHERE wlc.parent_lpn_id = p_parent_lpn_id
901: AND lpn.lpn_id = wlc.parent_lpn_id
902: AND lpn.organization_id = mp.organization_id
903: AND lpn.outermost_lpn_id = lpn3.lpn_id
983: , cst_cost_groups ccg
984: , mtl_item_locations mlc
985: , mtl_secondary_inventories msub
986: , mtl_lot_numbers mln
987: , mfg_lookups mlk
988:
989: WHERE lpn.organization_id = p_organization_id
990: AND wlc.inventory_item_id = p_inventory_item_id
991: AND lpn.lpn_id = wlc.parent_lpn_id