APPS.INV_MATERIAL_STATUS_GRP dependencies on WMS_LPN_CONTENTS

Line 89: FROM wms_lpn_contents wlc

85:
86: CURSOR c_lpn_item
87: IS
88: SELECT *
89: FROM wms_lpn_contents wlc
90: WHERE wlc.parent_lpn_id IN
91: (SELECT lpn_id
92: FROM wms_license_plate_numbers plpn
93: start with lpn_id = p_fromlpn_id

Line 522: FROM wms_lpn_contents wlc ,

518: INTO l_allow_transaction
519: FROM dual
520: WHERE EXISTS
521: (SELECT 1
522: FROM wms_lpn_contents wlc ,
523: mtl_serial_numbers msn,
524: mtl_status_transaction_control mtc
525: WHERE wlc.parent_lpn_id IN
526: (SELECT lpn_id

Line 3256: FROM wms_lpn_contents wlc

3252:
3253: CURSOR c_lpn_item
3254: IS
3255: SELECT *
3256: FROM wms_lpn_contents wlc
3257: WHERE wlc.parent_lpn_id IN
3258: (SELECT lpn_id
3259: FROM wms_license_plate_numbers plpn
3260: start with lpn_id = p_lpn_id

Line 3532: FROM mtl_onhand_quantities_detail moqd, wms_lpn_contents wlc

3528: IS
3529:
3530: CURSOR c_wlc_status IS
3531: SELECT moqd.inventory_item_id inventory_item_id,moqd.lot_number lot_number,moqd.status_id status_id
3532: FROM mtl_onhand_quantities_detail moqd, wms_lpn_contents wlc
3533: WHERE moqd.organization_id = p_org_id
3534: AND moqd.inventory_item_id = nvl(p_item_id,moqd.inventory_item_id)
3535: AND moqd.subinventory_code = p_subinv_code
3536: AND moqd.locator_id = p_locator_id

Line 3760: /*+ INDEX (WLC WMS_LPN_CONTENTS_N1) */

3756:
3757: CURSOR c_lpn_item(l_cur_inventory_item_id NUMBER)
3758: IS
3759: SELECT
3760: /*+ INDEX (WLC WMS_LPN_CONTENTS_N1) */
3761: *
3762: FROM wms_lpn_contents wlc
3763: WHERE wlc.parent_lpn_id IN
3764: (SELECT

Line 3762: FROM wms_lpn_contents wlc

3758: IS
3759: SELECT
3760: /*+ INDEX (WLC WMS_LPN_CONTENTS_N1) */
3761: *
3762: FROM wms_lpn_contents wlc
3763: WHERE wlc.parent_lpn_id IN
3764: (SELECT
3765: /*+ unnest cardinality(plpn, 1) */
3766: lpn_id