APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WMS_LPN_CONTENTS

Line 1342: wms_license_plate_numbers lpn, wms_lpn_contents wlc

1338:
1339: cursor sum_delivery_details(p_outermost_lpn_id IN NUMBER, p_delivery_id IN NUMBER) is
1340: select sum(wdd.requested_quantity), sum(wlc.quantity), wda.delivery_id, wlc.inventory_item_id, wlc.parent_lpn_id
1341: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2,
1342: wms_license_plate_numbers lpn, wms_lpn_contents wlc
1343: where wdd.delivery_detail_id = wda.delivery_detail_id
1344: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
1345: and wdd2.lpn_id = lpn.lpn_id
1346: and wdd2.released_status = 'X' -- For LPN reuse ER : 6845650

Line 5881: , wms_lpn_contents lpc

5877: decode(oel.component_number, null, null,decode(oel.option_number, null, '.',null)||
5878: '.'||to_char(oel.component_number)) like (p_order_line)
5879: and exists (select 1
5880: from wms_license_plate_numbers lpn
5881: , wms_lpn_contents lpc
5882: where lpn.outermost_lpn_id = p_outermost_lpn_id
5883: and lpn.lpn_id = lpc.parent_lpn_id
5884: and lpc.inventory_item_id = oel.inventory_item_id
5885: )

Line 5984: , wms_lpn_contents lpc

5980: decode(oel.component_number, null, null,decode(oel.option_number, null, '.',null)||
5981: '.'||to_char(oel.component_number)) like (p_order_line)
5982: and exists (select 1
5983: from wms_license_plate_numbers lpn
5984: , wms_lpn_contents lpc
5985: where lpn.outermost_lpn_id = p_outermost_lpn_id
5986: and lpn.lpn_id = lpc.parent_lpn_id
5987: and lpc.inventory_item_id = oel.inventory_item_id
5988: )

Line 6083: , wms_lpn_contents lpc

6079: decode(oel.component_number, null, null,decode(oel.option_number, null, '.',null)||
6080: '.'||to_char(oel.component_number)) like (p_order_line)
6081: and exists (select 1
6082: from wms_license_plate_numbers lpn
6083: , wms_lpn_contents lpc
6084: where lpn.outermost_lpn_id = p_outermost_lpn_id
6085: and lpn.lpn_id = lpc.parent_lpn_id
6086: and lpc.inventory_item_id = oel.inventory_item_id
6087: )

Line 6187: , wms_lpn_contents lpc

6183: decode(oel.component_number, null, null,decode(oel.option_number, null, '.',null)||
6184: '.'||to_char(oel.component_number)) like (p_order_line)
6185: and exists (select 1
6186: from wms_license_plate_numbers lpn
6187: , wms_lpn_contents lpc
6188: where lpn.outermost_lpn_id = p_outermost_lpn_id
6189: and lpn.lpn_id = lpc.parent_lpn_id
6190: and lpc.inventory_item_id = oel.inventory_item_id
6191: )

Line 6378: lpn_contents_select_str := lpn_contents_select_str || ' FROM wms_lpn_contents ';

6374: DEBUG('Starting to get the Contents' , 'GET_LPN_CONTENTS');
6375: END IF;
6376: lpn_id_str := '( ';
6377: lpn_contents_select_str := 'SELECT parent_lpn_id, inventory_item_id, quantity, uom_code, revision ';
6378: lpn_contents_select_str := lpn_contents_select_str || ' FROM wms_lpn_contents ';
6379: lpn_contents_select_str := lpn_contents_select_str || ' WHERE parent_lpn_id IN ';
6380:
6381: OPEN lpn_id_cursor;
6382: FETCH lpn_id_cursor INTO v_lpn_id;

Line 6737: TYPE lpn_id_tbl_type IS TABLE OF wms_lpn_contents.parent_lpn_id%TYPE;

6733: x_return_status OUT nocopy VARCHAR2,
6734: x_msg_count OUT nocopy NUMBER,
6735: x_msg_data OUT nocopy VARCHAR2) IS
6736:
6737: TYPE lpn_id_tbl_type IS TABLE OF wms_lpn_contents.parent_lpn_id%TYPE;
6738: TYPE inventory_item_id_tbl_type IS TABLE OF wms_lpn_contents.inventory_item_id%TYPE;
6739:
6740: l_parent_lpn_id lpn_id_tbl_type;
6741: l_inventory_item_id inventory_item_id_tbl_type;

Line 6738: TYPE inventory_item_id_tbl_type IS TABLE OF wms_lpn_contents.inventory_item_id%TYPE;

6734: x_msg_count OUT nocopy NUMBER,
6735: x_msg_data OUT nocopy VARCHAR2) IS
6736:
6737: TYPE lpn_id_tbl_type IS TABLE OF wms_lpn_contents.parent_lpn_id%TYPE;
6738: TYPE inventory_item_id_tbl_type IS TABLE OF wms_lpn_contents.inventory_item_id%TYPE;
6739:
6740: l_parent_lpn_id lpn_id_tbl_type;
6741: l_inventory_item_id inventory_item_id_tbl_type;
6742:

Line 6758: from wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_system_items_kfv msik

6754: x_return_status := 'S';
6755:
6756: SELECT wlc.parent_lpn_id, wlc.inventory_item_id
6757: bulk collect INTO l_parent_lpn_id, l_inventory_item_id
6758: from wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_system_items_kfv msik
6759: where wlc.organization_id = p_org_id
6760: and msik.organization_id = p_org_id
6761: and wlpn.organization_id = wlc.organization_id
6762: AND wlpn.outermost_lpn_id = p_outermost_lpn_id

Line 6778: UPDATE wms_lpn_contents

6774: END LOOP;
6775: END IF;
6776:
6777: forall i IN l_parent_lpn_id.first .. l_parent_lpn_id.last
6778: UPDATE wms_lpn_contents
6779: SET serial_summary_entry = 1
6780: WHERE parent_lpn_id = l_parent_lpn_id(i)
6781: AND inventory_item_id = l_inventory_item_id(i);
6782: ELSE