APPS.WMS_CONTAINER_PUB dependencies on WMS_LPN_CONTENTS

Line 1567: FROM wms_lpn_contents

1563: SELECT organization_id,
1564: lpn_content_id,
1565: parent_lpn_id,
1566: inventory_item_id
1567: FROM wms_lpn_contents
1568: WHERE parent_lpn_id = l_current_lpn;
1569: -- AND NVL(serial_summary_entry, 2) = 2;
1570:
1571: CURSOR lpn_serial_contents_cursor IS

Line 1586: --l_lpn_contents_rec WMS_LPN_CONTENTS%ROWTYPE;

1582: FROM wms_license_plate_numbers
1583: WHERE parent_lpn_id = l_current_lpn;
1584:
1585: l_lpn_rec wms_license_plate_numbers%ROWTYPE;
1586: --l_lpn_contents_rec WMS_LPN_CONTENTS%ROWTYPE;
1587: l_lpn_contents_rec lpn_contents_cursor%ROWTYPE;
1588: l_lpn_serial_rec mtl_serial_numbers%ROWTYPE;
1589: l_net_weight NUMBER;
1590: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 2020: FROM wms_lpn_contents

2016: SELECT organization_id,
2017: lpn_content_id,
2018: parent_lpn_id,
2019: inventory_item_id
2020: FROM wms_lpn_contents
2021: WHERE parent_lpn_id = l_current_lpn
2022: AND NVL(serial_summary_entry, 2) = 2;
2023:
2024: CURSOR lpn_serial_contents_cursor IS

Line 2045: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn

2041: -- Bug# 1546081
2042: -- SELECT wlc.*
2043: SELECT wlc.quantity,
2044: wlc.uom_code
2045: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
2046: WHERE wlc.parent_lpn_id = p_lpn_id
2047: AND wlc.organization_id = p_organization_id
2048: AND wlc.inventory_item_id = p_content_item_id
2049: AND NVL(wlc.revision, '###') = NVL(p_revision, '###')

Line 2075: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn

2071: wlc.source_line_id,
2072: wlc.source_line_detail_id,
2073: wlc.source_name,
2074: wlc.cost_group_id
2075: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
2076: WHERE wlc.parent_lpn_id = p_lpn_id
2077: AND wlc.organization_id = p_organization_id
2078: AND wlc.inventory_item_id = p_content_item_id
2079: AND NVL(wlc.revision, '###') = NVL(p_revision, '###')

Line 2119: FROM wms_lpn_contents

2115: AND lot_number = p_lot_number);
2116:
2117: CURSOR one_time_item_cursor IS
2118: SELECT quantity
2119: FROM wms_lpn_contents
2120: WHERE parent_lpn_id = p_lpn_id
2121: AND organization_id = p_organization_id
2122: AND item_description = p_content_item_desc
2123: AND NVL(cost_group_id, l_null_cost_group_val) = NVL(p_cost_group_id, l_null_cost_group_val)

Line 4208: , wms_lpn_contents wlc

4204: , l_outermost_lpn_name -- OUTERMOST_LICENSE_PLATE_NUMBER
4205: , wlpn1.homogeneous_container -- HOMOGENEOUS_CONTAINER
4206: FROM wms_license_plate_numbers wlpn1
4207: , wms_license_plate_numbers wlpn2
4208: , wms_lpn_contents wlc
4209: , mtl_serial_numbers msn
4210: WHERE wlpn1.lpn_id = wlc.parent_lpn_id(+)
4211: AND wlpn1.lpn_id = msn.lpn_id(+)
4212: AND wlpn1.lpn_id = wlpn2.parent_lpn_id(+)

Line 4219: DELETE FROM wms_lpn_contents

4215: IF l_debug = 1 THEN
4216: mdebug('Inserted wms_lpn_histories rows for lpn : '|| p_lpn_id);
4217: END IF;
4218:
4219: DELETE FROM wms_lpn_contents
4220: WHERE parent_lpn_id = p_lpn_id;
4221:
4222: IF p_clear_attributes = 'Y' THEN
4223: UPDATE wms_license_plate_numbers

Line 4477: , wms_lpn_contents wlc

4473: , l_outermost_lpn_name -- OUTERMOST_LICENSE_PLATE_NUMBER
4474: , wlpn1.homogeneous_container -- HOMOGENEOUS_CONTAINER
4475: FROM wms_license_plate_numbers wlpn1
4476: , wms_license_plate_numbers wlpn2
4477: , wms_lpn_contents wlc
4478: , mtl_serial_numbers msn
4479: WHERE wlpn1.lpn_id = wlc.parent_lpn_id(+)
4480: AND wlpn1.lpn_id = msn.lpn_id(+)
4481: AND wlpn1.lpn_id = wlpn2.parent_lpn_id(+)

Line 4484: DELETE FROM wms_lpn_contents

4480: AND wlpn1.lpn_id = msn.lpn_id(+)
4481: AND wlpn1.lpn_id = wlpn2.parent_lpn_id(+)
4482: AND wlpn1.lpn_id = all_child_wlpn_rec.lpn_id;
4483:
4484: DELETE FROM wms_lpn_contents
4485: WHERE parent_lpn_id = all_child_wlpn_rec.lpn_id;
4486:
4487:
4488: IF p_clear_attributes = 'Y' THEN