APPS.INV_CYC_LOVS dependencies on WMS_LPN_CONTENTS

Line 7259: FROM WMS_LPN_CONTENTS

7255:
7256: CURSOR lpn_contents_cursor
7257: IS
7258: SELECT *
7259: FROM WMS_LPN_CONTENTS
7260: WHERE parent_lpn_id = l_current_lpn
7261: AND NVL ( serial_summary_entry, 2 ) = 2;
7262:
7263: CURSOR lpn_serial_contents_cursor

Line 7272: FROM WMS_LPN_CONTENTS

7268:
7269: CURSOR lpn_multiple_serial_cursor
7270: IS
7271: SELECT *
7272: FROM WMS_LPN_CONTENTS
7273: WHERE parent_lpn_id = l_current_lpn AND serial_summary_entry = 1;
7274:
7275: --Bug#4891370.Added new cursor to query loaded quantity from LPN.
7276: CURSOR lpn_loaded_quantity_cur(p_inventory_item_id NUMBER,p_organization_id NUMBER,p_lpn_id NUMBER)

Line 7763: FROM wms_lpn_contents

7759: ELSIF ( p_parent_lpn_id IS NOT NULL ) THEN
7760: BEGIN
7761: SELECT DISTINCT NVL ( cost_group_id, -999 ) --bug3687177
7762: INTO l_cost_group_id
7763: FROM wms_lpn_contents
7764: WHERE parent_lpn_id = p_parent_lpn_id
7765: AND organization_id = p_organization_id
7766: AND inventory_item_id = p_inventory_item_id
7767: AND NVL ( revision, '@@@@@' ) = NVL ( p_revision, '@@@@@' )

Line 8916: FROM WMS_LPN_CONTENTS

8912: BEGIN
8913: --For R12 we need to consider primary_quantity instead of quantity from WLC (bug 6833992)
8914: SELECT nvl(sum(primary_quantity),0) --BUG3026540
8915: INTO x_system_quantity
8916: FROM WMS_LPN_CONTENTS
8917: WHERE parent_lpn_id = p_parent_lpn_id
8918: AND organization_id = p_organization_id
8919: AND inventory_item_id = p_inventory_item_id
8920: AND ( NVL ( lot_number, 'XX' ) =