APPS.INV_CYC_LOVS dependencies on WMS_LPN_CONTENTS

Line 7375: FROM WMS_LPN_CONTENTS

7371:
7372: CURSOR lpn_contents_cursor
7373: IS
7374: SELECT *
7375: FROM WMS_LPN_CONTENTS
7376: WHERE parent_lpn_id = l_current_lpn
7377: AND NVL ( serial_summary_entry, 2 ) = 2;
7378:
7379: CURSOR lpn_serial_contents_cursor

Line 7388: FROM WMS_LPN_CONTENTS

7384:
7385: CURSOR lpn_multiple_serial_cursor
7386: IS
7387: SELECT *
7388: FROM WMS_LPN_CONTENTS
7389: WHERE parent_lpn_id = l_current_lpn AND serial_summary_entry = 1;
7390:
7391: --Bug#4891370.Added new cursor to query loaded quantity from LPN.
7392: CURSOR lpn_loaded_quantity_cur(p_inventory_item_id NUMBER,p_organization_id NUMBER,p_lpn_id NUMBER)

Line 7959: FROM wms_lpn_contents

7955: ELSIF ( p_parent_lpn_id IS NOT NULL ) THEN
7956: BEGIN
7957: SELECT DISTINCT NVL ( cost_group_id, -999 ) --bug3687177
7958: INTO l_cost_group_id
7959: FROM wms_lpn_contents
7960: WHERE parent_lpn_id = p_parent_lpn_id
7961: AND organization_id = p_organization_id
7962: AND inventory_item_id = p_inventory_item_id
7963: AND NVL ( revision, '@@@@@' ) = NVL ( p_revision, '@@@@@' )

Line 9141: FROM WMS_LPN_CONTENTS

9137: BEGIN
9138: --For R12 we need to consider primary_quantity instead of quantity from WLC (bug 6833992)
9139: SELECT nvl(sum(primary_quantity),0) --BUG3026540
9140: INTO x_system_quantity
9141: FROM WMS_LPN_CONTENTS
9142: WHERE parent_lpn_id = p_parent_lpn_id
9143: AND organization_id = p_organization_id
9144: AND inventory_item_id = p_inventory_item_id
9145: AND ( NVL ( lot_number, 'XX' ) =