APPS.WMS_TASK_LOAD dependencies on WMS_LPN_CONTENTS

Line 7666: FROM wms_lpn_contents

7662:
7663: --8761670/8798363 start
7664: BEGIN
7665: SELECT Sum(quantity) INTO l_lpn_quantity
7666: FROM wms_lpn_contents
7667: WHERE parent_lpn_id = p_lpn_id
7668: AND organization_id = p_organization_id
7669: AND inventory_item_id = p_item_id ;
7670:

Line 8891: FROM wms_lpn_contents wlc

8887: INTO l_item_cnt
8888: FROM DUAL
8889: WHERE EXISTS(
8890: SELECT 1
8891: FROM wms_lpn_contents wlc
8892: WHERE wlc.parent_lpn_id = p_fromlpn_id
8893: AND wlc.organization_id = p_org_id
8894: AND wlc.inventory_item_id = p_item_id
8895: AND NVL(wlc.revision, '-999') = NVL(p_rev, '-999'));

Line 8920: FROM wms_lpn_contents wlc

8916: SELECT 1
8917: INTO l_item_cnt
8918: FROM DUAL
8919: WHERE EXISTS( SELECT 1
8920: FROM wms_lpn_contents wlc
8921: WHERE wlc.parent_lpn_id = p_fromlpn_id
8922: AND wlc.organization_id = p_org_id
8923: AND wlc.inventory_item_id = p_item_id
8924: AND NVL(wlc.revision, '-999') = NVL(p_rev, '-999')

Line 9027: FROM wms_lpn_contents

9023: INTO l_item_cnt2
9024: , l_lot_cnt
9025: , l_rev_cnt
9026: , l_cg_cnt
9027: FROM wms_lpn_contents
9028: WHERE parent_lpn_id = p_fromlpn_id
9029: AND organization_id = p_org_id;
9030:
9031: SELECT COUNT(*)

Line 11217: FROM wms_lpn_contents

11213:
11214: BEGIN
11215: SELECT NVL(SUM(primary_quantity),0), NVL(SUM(secondary_quantity),0)
11216: INTO l_lpn_qoh, l_lpn_sqoh
11217: FROM wms_lpn_contents
11218: WHERE parent_lpn_id = p_fromlpn_id
11219: AND inventory_item_id = p_item_id;
11220: EXCEPTION
11221: WHEN OTHERS THEN

Line 15466: FROM wms_lpn_contents wlc, mtl_transaction_lots_temp mtlt

15462: IS
15463: CURSOR c_lots_in_lpn
15464: IS
15465: SELECT mtlt.lot_number, 'Y' allocated_lot
15466: FROM wms_lpn_contents wlc, mtl_transaction_lots_temp mtlt
15467: WHERE wlc.parent_lpn_id = p_lpn_id
15468: AND wlc.organization_id = p_org_id
15469: AND wlc.inventory_item_id = p_item_id
15470: AND NVL (wlc.revision, '-999') = NVL (p_rev, '-999')

Line 15475: FROM wms_lpn_contents wlc

15471: AND mtlt.transaction_temp_id = p_transaction_temp_id
15472: AND mtlt.lot_number = wlc.lot_number
15473: UNION ALL
15474: SELECT lot_number, 'N' allocated_lot
15475: FROM wms_lpn_contents wlc
15476: WHERE wlc.parent_lpn_id = p_lpn_id
15477: AND wlc.organization_id = p_org_id
15478: AND wlc.inventory_item_id = p_item_id
15479: AND NVL (wlc.revision, '-999') = NVL (p_rev, '-999')

Line 15595: FROM wms_lpn_contents wlc

15591: mydebug ('lpn_has_unalloc_lots: p_transaction_temp_id: ' || p_transaction_temp_id);
15592:
15593: SELECT 1
15594: INTO l_unalloc_lots
15595: FROM wms_lpn_contents wlc
15596: WHERE wlc.parent_lpn_id = p_lpn_id -- add revision I think No need to add rev since x_match should take care.
15597: AND wlc.inventory_item_id = p_item_id
15598: AND NVL(wlc.revision,'-999') = NVL(p_rev,'-999')
15599: AND wlc.organization_id = p_organization_id