eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_TASK_DISPATCH_GEN dependencies on WMS_LPN_CONTENTS

Line 2978: FROM wms_lpn_contents wlc

2974: INTO l_item_cnt
2975: FROM DUAL
2976: WHERE EXISTS(
2977: SELECT 1
2978: FROM wms_lpn_contents wlc
2979: WHERE wlc.parent_lpn_id = p_lpn
2980: AND wlc.organization_id = p_org_id
2981: AND wlc.inventory_item_id = p_item_id
2982: AND NVL(wlc.revision, '-999') = NVL(p_rev, '-999'));

Line 3007: FROM wms_lpn_contents wlc, mtl_transaction_lots_temp mtlt

3003: INTO l_item_cnt
3004: FROM DUAL
3005: WHERE EXISTS(
3006: SELECT 1
3007: FROM wms_lpn_contents wlc, mtl_transaction_lots_temp mtlt
3008: WHERE wlc.parent_lpn_id = p_lpn
3009: AND wlc.organization_id = p_org_id
3010: AND wlc.inventory_item_id = p_item_id
3011: AND NVL(wlc.revision, '-999') = NVL(p_rev, '-999')

Line 3104: FROM wms_lpn_contents

3100: INTO l_item_cnt2
3101: , l_lot_cnt
3102: , l_rev_cnt
3103: , l_cg_cnt
3104: FROM wms_lpn_contents
3105: WHERE parent_lpn_id = p_lpn
3106: AND organization_id = p_org_id;
3107:
3108: SELECT COUNT(*)

Line 3151: wms_lpn_contents wlc

3147: l_lot_match,
3148: l_wlc_quantity,
3149: l_wlc_uom_code
3150: FROM
3151: wms_lpn_contents wlc
3152: WHERE wlc.parent_lpn_id = p_lpn
3153: AND wlc.inventory_item_id = p_item_id
3154: AND wlc.organization_id = p_org_id
3155: AND nvl(wlc.revision,'-999') = nvl(p_rev,'-999')

Line 3511: FROM wms_lpn_contents wlc

3507: p_uom,
3508: null,
3509: null) )
3510: INTO l_lpn_qty
3511: FROM wms_lpn_contents wlc
3512: WHERE wlc.parent_lpn_id = p_lpn
3513: AND wlc.inventory_item_id = p_item_id
3514: AND Nvl(wlc.revision, '-999') = Nvl(p_rev, '-999'); -- bug fix 2123096 */
3515: IF (l_debug = 1) THEN

Line 3837: wms_lpn_contents wlc

3833: l_lot_match,
3834: l_wlc_quantity,
3835: l_wlc_uom_code
3836: FROM
3837: wms_lpn_contents wlc
3838: WHERE wlc.parent_lpn_id = p_lpn
3839: AND wlc.inventory_item_id = p_item_id
3840: AND wlc.organization_id = p_org_id
3841: AND nvl(wlc.revision,'-999') = nvl(p_rev,'-999')

Line 4310: FROM wms_lpn_contents

4306: uom_code
4307: INTO
4308: l_exist_qty,
4309: l_lpn_uom
4310: FROM wms_lpn_contents
4311: WHERE parent_lpn_id = p_lpn
4312: AND organization_id = p_org_id
4313: AND inventory_item_id = p_item_id
4314: AND Nvl(cost_group_id,'-999') = Nvl(p_cost_group_id,'-999')

Line 6728: FROM wms_license_plate_numbers w, wms_lpn_contents c

6724: -- if yes, we cannot modify
6725: l_exist_lpn2 := 0;
6726:
6727: /* SELECT COUNT(*) INTO l_exist_lpn2
6728: FROM wms_license_plate_numbers w, wms_lpn_contents c
6729: WHERE w.license_plate_number=l_sug_lpn_name
6730: AND w.organization_id=l_org_id
6731: AND w.lpn_id=c.parent_lpn_id;*/
6732: BEGIN

Line 6737: FROM wms_license_plate_numbers w, wms_lpn_contents c

6733: SELECT 1
6734: INTO l_exist_lpn2
6735: FROM DUAL
6736: WHERE EXISTS(SELECT 1
6737: FROM wms_license_plate_numbers w, wms_lpn_contents c
6738: WHERE w.license_plate_number = l_sug_lpn_name
6739: AND w.organization_id = l_org_id
6740: AND w.lpn_id = c.parent_lpn_id);
6741: EXCEPTION

Line 6869: FROM wms_lpn_contents

6865: CURSOR lpn_lot_cur IS
6866: SELECT lot_number
6867: , quantity
6868: , uom_code
6869: FROM wms_lpn_contents
6870: WHERE parent_lpn_id = p_lpn_id;
6871:
6872: CURSOR mtlt_lot_cur(v_lot_number VARCHAR2) IS
6873: SELECT *

Line 13970: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc

13966: ELSE
13967: -- It however remains same for LPNs
13968: SELECT COUNT(*)
13969: INTO x_lot_num_lov_count
13970: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc
13971: WHERE mln.organization_id = p_organization_id
13972: AND mln.inventory_item_id = p_item_id
13973: AND mln.lot_number LIKE(p_lot_number || '%')
13974: AND moq.lot_number = mln.lot_number

Line 14037: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc

14033: ) = 'Y';
14034: ELSE
14035: SELECT COUNT(*)
14036: INTO x_lot_num_lov_count
14037: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc
14038: WHERE mln.organization_id = p_organization_id
14039: AND mln.inventory_item_id = p_item_id
14040: AND mln.lot_number LIKE(p_lot_number || '%')
14041: AND moq.lot_number = mln.lot_number