APPS.INV_TXN_VALIDATIONS dependencies on WMS_LPN_CONTENTS

Line 2612: FROM wms_lpn_contents wlc,

2608: wlc.parent_lpn_id, -- lpn reservation change
2609: --SUM(wlc.quantity) sumqty, lpn reservation change
2610: wlc.revision,
2611: wlpn.lpn_context, wlc.lot_number
2612: FROM wms_lpn_contents wlc,
2613: wms_license_plate_numbers wlpn
2614: WHERE wlpn.outermost_lpn_id = p_lpn_id
2615: AND wlpn.organization_id = p_organization_id
2616: AND wlc.parent_lpn_id = wlpn.lpn_id

Line 2636: -- FROM wms_lpn_contents wlc,

2632:
2633: -- OPTIMIZED BELOW FOR PERFORMANCE MXGUPTA JUNE 4 2001
2634: -- SELECT DISTINCT wlpn.subinventory_code, wlpn.locator_id
2635: -- INTO l_subinventory_code, l_locator_id
2636: -- FROM wms_lpn_contents wlc,
2637: -- wms_license_plate_numbers wlpn
2638: -- WHERE wlpn.organization_id = p_organization_id
2639: -- AND wlpn.outermost_lpn_id = p_lpn_id
2640: -- AND wlc.parent_lpn_id = wlpn.lpn_id;

Line 2845: FROM wms_lpn_contents wlc,

2841: wlc.parent_lpn_id, -- lpn reservation change
2842: -- SUM(wlc.quantity) sumqty,
2843: wlc.revision,
2844: wlpn.lpn_context, wlc.lot_number
2845: FROM wms_lpn_contents wlc,
2846: wms_license_plate_numbers wlpn
2847: WHERE wlpn.outermost_lpn_id = p_lpn_id
2848: AND wlpn.organization_id = p_organization_id
2849: AND wlc.parent_lpn_id = wlpn.lpn_id

Line 2873: -- FROM wms_lpn_contents wlc,

2869:
2870: -- OPTIMIZED BELOW FOR PERFORMANCE MXGUPTA JUNE 4 2001
2871: -- SELECT DISTINCT wlpn.subinventory_code, wlpn.locator_id
2872: -- INTO l_subinventory_code, l_locator_id
2873: -- FROM wms_lpn_contents wlc,
2874: -- wms_license_plate_numbers wlpn
2875: -- WHERE wlpn.organization_id = p_organization_id
2876: -- AND wlpn.outermost_lpn_id = p_lpn_id
2877: -- AND wlc.parent_lpn_id = wlpn.lpn_id;

Line 3131: FROM wms_lpn_contents

3127: /* comment out for lpn reservation ??? how can we get immediate lpn item quantity by calling
3128: quantity tree API using new tree mode ?????
3129: SELECT SUM(quantity)
3130: INTO x_lpn_onhand
3131: FROM wms_lpn_contents
3132: WHERE parent_lpn_id = p_lpn_id
3133: AND inventory_item_id = p_inventory_item_id
3134: AND organization_id = p_organization_id
3135: AND (p_lot_number IS NULL OR lot_number = p_lot_number)

Line 3311: FROM wms_lpn_contents

3307: /* comment out for lpn reservation ??? how can we get immediate lpn item quantity by calling
3308: quantity tree API using new tree mode ?????
3309: SELECT SUM(quantity)
3310: INTO x_lpn_onhand
3311: FROM wms_lpn_contents
3312: WHERE parent_lpn_id = p_lpn_id
3313: AND inventory_item_id = p_inventory_item_id
3314: AND organization_id = p_organization_id
3315: AND (p_lot_number IS NULL OR lot_number = p_lot_number)

Line 3485: FROM wms_lpn_contents

3481: /* comment out for lpn reservation ??? how can we get immediate lpn item quantity by calling
3482: quantity tree API using new tree mode ?????
3483: SELECT SUM(quantity)
3484: INTO x_lpn_onhand
3485: FROM wms_lpn_contents
3486: WHERE parent_lpn_id = p_lpn_id
3487: AND inventory_item_id = p_inventory_item_id
3488: AND organization_id = p_organization_id
3489: AND (p_lot_number IS NULL OR lot_number = p_lot_number)

Line 3654: from wms_lpn_contents

3650: --BugFix 3701796 SQL sum function changed to primary quantity
3651: OPEN x_lot_qty FOR
3652: select lot_number,
3653: SUM(inv_decimals_pub.get_primary_quantity(p_org_id,inventory_item_id,uom_code,Nvl(quantity,0))) primary_quantity
3654: from wms_lpn_contents
3655: where inventory_item_id = p_item_id
3656: and parent_lpn_id = p_lpn_id
3657: and ((revision = p_revision and p_revision is not null) or
3658: (p_revision is null and revision is null))

Line 3679: from wms_lpn_contents

3675: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3676: BEGIN
3677: OPEN x_tot_qty FOR
3678: select sum(quantity)
3679: from wms_lpn_contents
3680: where inventory_item_id = p_item_id
3681: and parent_lpn_id = p_lpn_id
3682: and ((revision = p_revision and p_revision is not null) or
3683: (p_revision is null and revision is null))