APPS.WMS_CONTAINER_PUB dependencies on WMS_LPN_CONTENTS

Line 1490: FROM wms_lpn_contents

1486: SELECT organization_id,
1487: lpn_content_id,
1488: parent_lpn_id,
1489: inventory_item_id
1490: FROM wms_lpn_contents
1491: WHERE parent_lpn_id = l_current_lpn;
1492: -- AND NVL(serial_summary_entry, 2) = 2;
1493:
1494: CURSOR lpn_serial_contents_cursor IS

Line 1509: --l_lpn_contents_rec WMS_LPN_CONTENTS%ROWTYPE;

1505: FROM wms_license_plate_numbers
1506: WHERE parent_lpn_id = l_current_lpn;
1507:
1508: l_lpn_rec wms_license_plate_numbers%ROWTYPE;
1509: --l_lpn_contents_rec WMS_LPN_CONTENTS%ROWTYPE;
1510: l_lpn_contents_rec lpn_contents_cursor%ROWTYPE;
1511: l_lpn_serial_rec mtl_serial_numbers%ROWTYPE;
1512: l_net_weight NUMBER;
1513: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 1943: FROM wms_lpn_contents

1939: SELECT organization_id,
1940: lpn_content_id,
1941: parent_lpn_id,
1942: inventory_item_id
1943: FROM wms_lpn_contents
1944: WHERE parent_lpn_id = l_current_lpn
1945: AND NVL(serial_summary_entry, 2) = 2;
1946:
1947: CURSOR lpn_serial_contents_cursor IS

Line 1968: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn

1964: -- Bug# 1546081
1965: -- SELECT wlc.*
1966: SELECT wlc.quantity,
1967: wlc.uom_code
1968: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
1969: WHERE wlc.parent_lpn_id = p_lpn_id
1970: AND wlc.organization_id = p_organization_id
1971: AND wlc.inventory_item_id = p_content_item_id
1972: AND NVL(wlc.revision, '###') = NVL(p_revision, '###')

Line 1998: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn

1994: wlc.source_line_id,
1995: wlc.source_line_detail_id,
1996: wlc.source_name,
1997: wlc.cost_group_id
1998: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
1999: WHERE wlc.parent_lpn_id = p_lpn_id
2000: AND wlc.organization_id = p_organization_id
2001: AND wlc.inventory_item_id = p_content_item_id
2002: AND NVL(wlc.revision, '###') = NVL(p_revision, '###')

Line 2042: FROM wms_lpn_contents

2038: AND lot_number = p_lot_number);
2039:
2040: CURSOR one_time_item_cursor IS
2041: SELECT quantity
2042: FROM wms_lpn_contents
2043: WHERE parent_lpn_id = p_lpn_id
2044: AND organization_id = p_organization_id
2045: AND item_description = p_content_item_desc
2046: AND NVL(cost_group_id, l_null_cost_group_val) = NVL(p_cost_group_id, l_null_cost_group_val)

Line 4130: , wms_lpn_contents wlc

4126: , l_outermost_lpn_name -- OUTERMOST_LICENSE_PLATE_NUMBER
4127: , wlpn1.homogeneous_container -- HOMOGENEOUS_CONTAINER
4128: FROM wms_license_plate_numbers wlpn1
4129: , wms_license_plate_numbers wlpn2
4130: , wms_lpn_contents wlc
4131: , mtl_serial_numbers msn
4132: WHERE wlpn1.lpn_id = wlc.parent_lpn_id(+)
4133: AND wlpn1.lpn_id = msn.lpn_id(+)
4134: AND wlpn1.lpn_id = wlpn2.parent_lpn_id(+)

Line 4141: DELETE FROM wms_lpn_contents

4137: IF l_debug = 1 THEN
4138: mdebug('Inserted wms_lpn_histories rows for lpn : '|| p_lpn_id);
4139: END IF;
4140:
4141: DELETE FROM wms_lpn_contents
4142: WHERE parent_lpn_id = p_lpn_id;
4143:
4144: IF p_clear_attributes = 'Y' THEN
4145: UPDATE wms_license_plate_numbers

Line 4399: , wms_lpn_contents wlc

4395: , l_outermost_lpn_name -- OUTERMOST_LICENSE_PLATE_NUMBER
4396: , wlpn1.homogeneous_container -- HOMOGENEOUS_CONTAINER
4397: FROM wms_license_plate_numbers wlpn1
4398: , wms_license_plate_numbers wlpn2
4399: , wms_lpn_contents wlc
4400: , mtl_serial_numbers msn
4401: WHERE wlpn1.lpn_id = wlc.parent_lpn_id(+)
4402: AND wlpn1.lpn_id = msn.lpn_id(+)
4403: AND wlpn1.lpn_id = wlpn2.parent_lpn_id(+)

Line 4406: DELETE FROM wms_lpn_contents

4402: AND wlpn1.lpn_id = msn.lpn_id(+)
4403: AND wlpn1.lpn_id = wlpn2.parent_lpn_id(+)
4404: AND wlpn1.lpn_id = all_child_wlpn_rec.lpn_id;
4405:
4406: DELETE FROM wms_lpn_contents
4407: WHERE parent_lpn_id = all_child_wlpn_rec.lpn_id;
4408:
4409:
4410: IF p_clear_attributes = 'Y' THEN