DBA Data[Home] [Help]

APPS.WMS_CONSOLIDATION_PUB dependencies on WMS_LPN_CONTENTS

Line 1771: wms_lpn_contents wlc,

1767: IF (g_trace_on = 1) THEN mydebug('after pn validations ...:: ' ); END IF;
1768: SELECT wlc.inventory_item_id
1769: INTO l_item_id
1770: FROM
1771: wms_lpn_contents wlc,
1772: wms_license_plate_numbers wlpn
1773: WHERE wlc.parent_lpn_id = wlpn.lpn_id
1774: AND wlc.organization_id = wlpn.organization_id
1775: AND wlpn.outermost_lpn_id = l_lpn_id

Line 2834: wms_lpn_contents wlc,

2830:
2831: SELECT wlc.inventory_item_id
2832: INTO l_item_id
2833: FROM
2834: wms_lpn_contents wlc,
2835: wms_license_plate_numbers wlpn
2836: WHERE wlc.parent_lpn_id = wlpn.lpn_id
2837: AND wlc.organization_id = wlpn.organization_id
2838: AND wlpn.outermost_lpn_id = p_lpn_id