DBA Data[Home] [Help]

APPS.WMS_CONSOLIDATION_PUB dependencies on WMS_LPN_CONTENTS

Line 1766: wms_lpn_contents wlc,

1762: IF (g_trace_on = 1) THEN mydebug('after pn validations ...:: ' ); END IF;
1763: SELECT wlc.inventory_item_id
1764: INTO l_item_id
1765: FROM
1766: wms_lpn_contents wlc,
1767: wms_license_plate_numbers wlpn
1768: WHERE wlc.parent_lpn_id = wlpn.lpn_id
1769: AND wlc.organization_id = wlpn.organization_id
1770: AND wlpn.outermost_lpn_id = l_lpn_id

Line 2740: wms_lpn_contents wlc,

2736:
2737: SELECT wlc.inventory_item_id
2738: INTO l_item_id
2739: FROM
2740: wms_lpn_contents wlc,
2741: wms_license_plate_numbers wlpn
2742: WHERE wlc.parent_lpn_id = wlpn.lpn_id
2743: AND wlc.organization_id = wlpn.organization_id
2744: AND wlpn.outermost_lpn_id = p_lpn_id