DBA Data[Home] [Help]

APPS.GML_MOBILE_SHIP_CONFIRM dependencies on MTL_SYSTEM_ITEMS_KFV

Line 113: wsh_delivery_assignments da, mtl_system_items_kfv msik

109: nvl(dd.transaction_temp_id,0),
110: dd.picked_quantity, dd.requested_quantity_uom2, NVL(dd.lot_number, ' '), NVL(dd.picked_quantity2,0)
111: ---FROM wsh_new_deliveries_ob_grp_v del, wsh_delivery_details_ob_grp_v dd,
112: FROM wsh_new_deliveries del, wsh_delivery_details dd,
113: wsh_delivery_assignments da, mtl_system_items_kfv msik
114: WHERE da.delivery_id = del.delivery_id
115: AND da.delivery_detail_id = dd.delivery_detail_id
116: AND ( dd.inventory_item_id = p_inventory_item_id or p_inventory_item_id = -1 )
117: AND NVL( dd.inv_interfaced_flag, 'N') = 'N'

Line 750: FROM mtl_system_items_kfv msik, wsh_delivery_details dd, wsh_delivery_assignments da,

746: OPEN x_items FOR
747: SELECT DISTINCT msik.concatenated_segments concatenated_segments
748: , msik.inventory_item_id
749: , msik.description
750: FROM mtl_system_items_kfv msik, wsh_delivery_details dd, wsh_delivery_assignments da,
751: wsh_new_deliveries nd
752: WHERE msik.concatenated_segments LIKE (p_concatenated_segments)
753: AND msik.organization_id = p_organization_id
754: AND msik.inventory_item_id = dd.inventory_item_id

Line 769: FROM mtl_system_items_kfv msik,

765:
766: SELECT DISTINCT msik.concatenated_segments concatenated_segments
767: , msik.inventory_item_id
768: , msik.description
769: FROM mtl_system_items_kfv msik,
770: wsh_delivery_details dd,
771: wsh_delivery_assignments da,
772: wsh_new_deliveries nd,
773: mtl_cross_references mcr