APPS.INV_TXN_VALIDATIONS dependencies on WMS_LPN_CONTENTS

Line 2358: FROM wms_lpn_contents wlc,

2354: wlc.parent_lpn_id, -- lpn reservation change
2355: --SUM(wlc.quantity) sumqty, lpn reservation change
2356: wlc.revision,
2357: wlpn.lpn_context, wlc.lot_number
2358: FROM wms_lpn_contents wlc,
2359: wms_license_plate_numbers wlpn
2360: WHERE wlpn.outermost_lpn_id = p_lpn_id
2361: AND wlpn.organization_id = p_organization_id
2362: AND wlc.parent_lpn_id = wlpn.lpn_id

Line 2382: -- FROM wms_lpn_contents wlc,

2378:
2379: -- OPTIMIZED BELOW FOR PERFORMANCE MXGUPTA JUNE 4 2001
2380: -- SELECT DISTINCT wlpn.subinventory_code, wlpn.locator_id
2381: -- INTO l_subinventory_code, l_locator_id
2382: -- FROM wms_lpn_contents wlc,
2383: -- wms_license_plate_numbers wlpn
2384: -- WHERE wlpn.organization_id = p_organization_id
2385: -- AND wlpn.outermost_lpn_id = p_lpn_id
2386: -- AND wlc.parent_lpn_id = wlpn.lpn_id;

Line 2590: FROM wms_lpn_contents wlc,

2586: wlc.parent_lpn_id, -- lpn reservation change
2587: -- SUM(wlc.quantity) sumqty,
2588: wlc.revision,
2589: wlpn.lpn_context, wlc.lot_number
2590: FROM wms_lpn_contents wlc,
2591: wms_license_plate_numbers wlpn
2592: WHERE wlpn.outermost_lpn_id = p_lpn_id
2593: AND wlpn.organization_id = p_organization_id
2594: AND wlc.parent_lpn_id = wlpn.lpn_id

Line 2618: -- FROM wms_lpn_contents wlc,

2614:
2615: -- OPTIMIZED BELOW FOR PERFORMANCE MXGUPTA JUNE 4 2001
2616: -- SELECT DISTINCT wlpn.subinventory_code, wlpn.locator_id
2617: -- INTO l_subinventory_code, l_locator_id
2618: -- FROM wms_lpn_contents wlc,
2619: -- wms_license_plate_numbers wlpn
2620: -- WHERE wlpn.organization_id = p_organization_id
2621: -- AND wlpn.outermost_lpn_id = p_lpn_id
2622: -- AND wlc.parent_lpn_id = wlpn.lpn_id;

Line 2852: FROM wms_lpn_contents

2848: /* comment out for lpn reservation ??? how can we get immediate lpn item quantity by calling
2849: quantity tree API using new tree mode ?????
2850: SELECT SUM(quantity)
2851: INTO x_lpn_onhand
2852: FROM wms_lpn_contents
2853: WHERE parent_lpn_id = p_lpn_id
2854: AND inventory_item_id = p_inventory_item_id
2855: AND organization_id = p_organization_id
2856: AND (p_lot_number IS NULL OR lot_number = p_lot_number)

Line 3032: FROM wms_lpn_contents

3028: /* comment out for lpn reservation ??? how can we get immediate lpn item quantity by calling
3029: quantity tree API using new tree mode ?????
3030: SELECT SUM(quantity)
3031: INTO x_lpn_onhand
3032: FROM wms_lpn_contents
3033: WHERE parent_lpn_id = p_lpn_id
3034: AND inventory_item_id = p_inventory_item_id
3035: AND organization_id = p_organization_id
3036: AND (p_lot_number IS NULL OR lot_number = p_lot_number)

Line 3206: FROM wms_lpn_contents

3202: /* comment out for lpn reservation ??? how can we get immediate lpn item quantity by calling
3203: quantity tree API using new tree mode ?????
3204: SELECT SUM(quantity)
3205: INTO x_lpn_onhand
3206: FROM wms_lpn_contents
3207: WHERE parent_lpn_id = p_lpn_id
3208: AND inventory_item_id = p_inventory_item_id
3209: AND organization_id = p_organization_id
3210: AND (p_lot_number IS NULL OR lot_number = p_lot_number)

Line 3375: from wms_lpn_contents

3371: --BugFix 3701796 SQL sum function changed to primary quantity
3372: OPEN x_lot_qty FOR
3373: select lot_number,
3374: SUM(inv_decimals_pub.get_primary_quantity(p_org_id,inventory_item_id,uom_code,Nvl(quantity,0))) primary_quantity
3375: from wms_lpn_contents
3376: where inventory_item_id = p_item_id
3377: and parent_lpn_id = p_lpn_id
3378: and ((revision = p_revision and p_revision is not null) or
3379: (p_revision is null and revision is null))

Line 3400: from wms_lpn_contents

3396: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3397: BEGIN
3398: OPEN x_tot_qty FOR
3399: select sum(quantity)
3400: from wms_lpn_contents
3401: where inventory_item_id = p_item_id
3402: and parent_lpn_id = p_lpn_id
3403: and ((revision = p_revision and p_revision is not null) or
3404: (p_revision is null and revision is null))