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.INV_CONSIGNED_VALIDATIONS dependencies on MTL_LOT_NUMBERS

Line 711: , mtl_lot_numbers lot';

707: , x.lot_number lot_number ';
708: l_lot_select2 := '
709: , lot.expiration_date lot_expiration_date';
710: l_lot_from := '
711: , mtl_lot_numbers lot';
712: l_lot_where := '
713: AND x.organization_id = lot.organization_id (+)
714: AND x.inventory_item_id = lot.inventory_item_id (+)
715: AND x.lot_number = lot.lot_number (+) ';

Line 1246: FROM mtl_lot_numbers mln

1242: CURSOR is_RSV_lot( org_id IN NUMBER
1243: , item_id IN NUMBER
1244: , lot IN VARCHAR2) IS
1245: SELECT '1'
1246: FROM mtl_lot_numbers mln
1247: WHERE mln.status_id IN
1248: (SELECT mms.status_id
1249: FROM mtl_material_statuses mms
1250: WHERE NVL(mms.attribute1, '1') = '1'

Line 2260: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_secondary_inventories msi

2256: SELECT SUM(moq.primary_transaction_quantity)
2257: , SUM( NVL(moq.secondary_transaction_quantity, 0))
2258: INTO l_moq_qty
2259: , l_moq_sqty
2260: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_secondary_inventories msi
2261: WHERE moq.organization_id = p_org_id
2262: AND moq.inventory_item_id = p_item_id
2263: AND msi.organization_id = moq.organization_id
2264: AND msi.secondary_inventory_name = moq.subinventory_code

Line 2279: FROM mtl_onhand_net mon, mtl_lot_numbers mln

2275: SELECT SUM(mon.primary_transaction_quantity)
2276: , SUM( NVL(mon.secondary_transaction_quantity, 0))
2277: INTO l_moq_qty
2278: , l_moq_sqty
2279: FROM mtl_onhand_net mon, mtl_lot_numbers mln
2280: WHERE mon.organization_id = p_org_id
2281: AND mon.inventory_item_id = p_item_id
2282: AND mon.organization_id = nvl(mon.planning_organization_id, mon.organization_id)
2283: AND mon.lot_number = mln.lot_number(+)

Line 2325: AND EXISTS (SELECT 'x' FROM mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln

2321: WHERE msi.organization_id = mmtt.organization_id
2322: AND msi.secondary_inventory_name = mmtt.subinventory_code
2323: AND msi.availability_type = decode(p_include_nonnet,1,msi.availability_type,1))
2324: AND mmtt.planning_organization_id IS NULL
2325: AND EXISTS (SELECT 'x' FROM mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln
2326: WHERE mtlt.transaction_temp_id = mmtt.transaction_temp_id
2327: AND mtlt.lot_number = mln.lot_number(+)
2328: AND p_org_id = mln.organization_id(+)
2329: AND p_item_id = mln.inventory_item_id(+)

Line 2378: SELECT 'x' FROM mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln

2374: )
2375: AND mmtt.planning_organization_id IS NULL
2376: AND EXISTS
2377: (
2378: SELECT 'x' FROM mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln
2379: WHERE mtlt.transaction_temp_id = mmtt.transaction_temp_id
2380: AND mtlt.lot_number = mln.lot_number (+)
2381: AND decode(mmtt.transaction_action_id,
2382: 3, mmtt.transfer_organization,mmtt.organization_id) = mln.organization_id(+)

Line 2437: AND EXISTS (SELECT 'x' FROM mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln

2433: WHERE msi.organization_id = mmtt.organization_id
2434: AND msi.secondary_inventory_name = mmtt.subinventory_code
2435: )
2436: AND mmtt.planning_organization_id IS NULL
2437: AND EXISTS (SELECT 'x' FROM mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln
2438: WHERE mtlt.transaction_temp_id = mmtt.transaction_temp_id
2439: AND mtlt.lot_number = mln.lot_number(+)
2440: AND p_org_id = mln.organization_id(+)
2441: AND p_item_id = mln.inventory_item_id(+)

Line 2494: SELECT 'x' FROM mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln

2490: )
2491: AND mmtt.planning_organization_id IS NULL
2492: AND EXISTS
2493: (
2494: SELECT 'x' FROM mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln
2495: WHERE mtlt.transaction_temp_id = mmtt.transaction_temp_id
2496: AND mtlt.lot_number = mln.lot_number (+)
2497: AND decode(mmtt.transaction_action_id,
2498: 3, mmtt.transfer_organization,mmtt.organization_id) = mln.organization_id(+)

Line 2755: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln

2751: SELECT SUM(moq.primary_transaction_quantity)
2752: , SUM( NVL(moq.secondary_transaction_quantity, 0))
2753: INTO l_moq_qty
2754: , l_moq_sqty
2755: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln
2756: WHERE moq.organization_id = p_org_id
2757: AND moq.inventory_item_id = p_item_id
2758: AND moq.subinventory_code = p_subinv
2759: AND moq.lot_number = mln.lot_number(+)

Line 2783: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln

2779: AND mmtt.subinventory_code = p_subinv
2780: AND mmtt.posting_flag = 'Y'
2781: AND mmtt.subinventory_code IS NOT NULL
2782: AND Nvl(mmtt.transaction_status,0) <> 2
2783: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln
2784: WHERE mtlt.transaction_temp_id = mmtt.transaction_temp_id
2785: AND mtlt.lot_number = mln.lot_number (+)
2786: AND p_org_id = mln.organization_id(+)
2787: AND p_item_id = mln.inventory_item_id(+)

Line 2806: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln

2802: AND mmtt.inventory_item_id = p_item_id
2803: AND mmtt.transfer_subinventory = p_subinv
2804: AND mmtt.posting_flag = 'Y'
2805: AND Nvl(mmtt.transaction_status,0) <> 2
2806: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln
2807: WHERE mtlt.transaction_temp_id = mmtt.transaction_temp_id
2808: AND mtlt.lot_number = mln.lot_number (+)
2809: AND decode(mmtt.transaction_action_id,3,
2810: mmtt.transfer_organization,mmtt.organization_id) = mln.organization_id(+)

Line 2962: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln

2958:
2959: IF (p_onhand_source = g_atpable_only) THEN
2960: SELECT SUM(moq.primary_transaction_quantity)
2961: INTO l_moq_qty
2962: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln
2963: WHERE moq.organization_id = p_org_id
2964: AND moq.inventory_item_id = p_item_id
2965: AND EXISTS (select 'x' from mtl_secondary_inventories msi
2966: WHERE msi.organization_id = moq.organization_id and

Line 2978: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln

2974: AND nvl(moq.planning_tp_type,2) = 2;
2975: ELSE
2976: SELECT SUM(moq.primary_transaction_quantity)
2977: INTO l_moq_qty
2978: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln
2979: WHERE moq.organization_id = p_org_id
2980: AND moq.inventory_item_id = p_item_id
2981: AND EXISTS
2982: (select 'x' from mtl_secondary_inventories msi

Line 3017: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln

3013: WHERE msi.organization_id = mmtt.organization_id
3014: AND msi.secondary_inventory_name = mmtt.subinventory_code
3015: AND nvl(msi.inventory_atp_code,1) = 1)
3016: AND mmtt.planning_organization_id IS NULL
3017: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln
3018: WHERE mtlt.transaction_temp_id = mmtt.transaction_temp_id
3019: AND mtlt.lot_number = mln.lot_number(+)
3020: AND p_org_id = mln.organization_id(+)
3021: AND p_item_id = mln.inventory_item_id(+)

Line 3043: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln

3039: WHERE msi.organization_id = mmtt.organization_id
3040: AND msi.secondary_inventory_name = mmtt.subinventory_code
3041: AND msi.availability_type = decode(p_onhand_source,g_all_subs,msi.availability_type,1))
3042: AND mmtt.planning_organization_id IS NULL
3043: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln
3044: WHERE mtlt.transaction_temp_id = mmtt.transaction_temp_id
3045: AND mtlt.lot_number = mln.lot_number(+)
3046: AND p_org_id = mln.organization_id(+)
3047: AND p_item_id = mln.inventory_item_id(+)

Line 3077: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln

3073: 3, mmtt.transfer_organization,mmtt.organization_id)
3074: AND msi.secondary_inventory_name = mmtt.transfer_subinventory
3075: AND nvl(msi.inventory_atp_code,1) = 1)))
3076: AND mmtt.planning_organization_id IS NULL
3077: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln
3078: WHERE mtlt.transaction_temp_id = mmtt.transaction_temp_id
3079: AND mtlt.lot_number = mln.lot_number (+)
3080: AND decode(mmtt.transaction_action_id,
3081: 3, mmtt.transfer_organization,mmtt.organization_id) = mln.organization_id(+)

Line 3105: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln

3101: 3, mmtt.transfer_organization,mmtt.organization_id)
3102: AND msi.secondary_inventory_name = mmtt.transfer_subinventory
3103: AND msi.availability_type = decode(p_onhand_source,g_all_subs,msi.availability_type,1))))
3104: AND mmtt.planning_organization_id IS NULL
3105: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln
3106: WHERE mtlt.transaction_temp_id = mmtt.transaction_temp_id
3107: AND mtlt.lot_number = mln.lot_number (+)
3108: AND decode(mmtt.transaction_action_id,
3109: 3, mmtt.transfer_organization,mmtt.organization_id) = mln.organization_id(+)

Line 3224: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln

3220:
3221: IF (p_onhand_source = g_atpable_only) THEN
3222: SELECT SUM(moq.primary_transaction_quantity)
3223: INTO l_moq_qty
3224: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln
3225: WHERE moq.organization_id = p_org_id
3226: AND moq.inventory_item_id = p_item_id
3227: AND EXISTS (select 'x' from mtl_secondary_inventories msi
3228: WHERE msi.organization_id = moq.organization_id and

Line 3249: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln

3245: );
3246: ELSE
3247: SELECT SUM(moq.primary_transaction_quantity)
3248: INTO l_moq_qty
3249: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln
3250: WHERE moq.organization_id = p_org_id
3251: AND moq.inventory_item_id = p_item_id
3252: AND EXISTS
3253: (select 'x' from mtl_secondary_inventories msi

Line 3297: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln

3293: AND EXISTS (select 'x' from mtl_secondary_inventories msi
3294: WHERE msi.organization_id = mmtt.organization_id
3295: AND msi.secondary_inventory_name = mmtt.subinventory_code)
3296: AND mmtt.planning_organization_id IS NULL
3297: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln
3298: WHERE mtlt.transaction_temp_id = mmtt.transaction_temp_id
3299: AND mtlt.lot_number = mln.lot_number(+)
3300: AND p_org_id = mln.organization_id(+)
3301: AND p_item_id = mln.inventory_item_id(+)

Line 3331: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln

3327: (select 'x' from mtl_secondary_inventories msi
3328: WHERE msi.organization_id = mmtt.organization_id
3329: AND msi.secondary_inventory_name = mmtt.subinventory_code)
3330: AND mmtt.planning_organization_id IS NULL
3331: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln
3332: WHERE mtlt.transaction_temp_id = mmtt.transaction_temp_id
3333: AND mtlt.lot_number = mln.lot_number(+)
3334: AND p_org_id = mln.organization_id(+)
3335: AND p_item_id = mln.inventory_item_id(+)

Line 3373: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln

3369: WHERE msi.organization_id = decode(mmtt.transaction_action_id,
3370: 3, mmtt.transfer_organization,mmtt.organization_id)
3371: AND msi.secondary_inventory_name = mmtt.transfer_subinventory )))
3372: AND mmtt.planning_organization_id IS NULL
3373: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln
3374: WHERE mtlt.transaction_temp_id = mmtt.transaction_temp_id
3375: AND mtlt.lot_number = mln.lot_number (+)
3376: AND decode(mmtt.transaction_action_id,
3377: 3, mmtt.transfer_organization,mmtt.organization_id) = mln.organization_id(+)

Line 3415: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln

3411: WHERE msi.organization_id = decode(mmtt.transaction_action_id,
3412: 3, mmtt.transfer_organization,mmtt.organization_id)
3413: AND msi.secondary_inventory_name = mmtt.transfer_subinventory)))
3414: AND mmtt.planning_organization_id IS NULL
3415: AND EXISTS (select 'x' from mtl_transaction_lots_temp mtlt, mtl_lot_numbers mln
3416: WHERE mtlt.transaction_temp_id = mmtt.transaction_temp_id
3417: AND mtlt.lot_number = mln.lot_number (+)
3418: AND decode(mmtt.transaction_action_id,
3419: 3, mmtt.transfer_organization,mmtt.organization_id) = mln.organization_id(+)

Line 3716: , mtl_lot_numbers lot';

3712: , x.lot_number lot_number ';
3713: l_lot_select2 := '
3714: , lot.expiration_date lot_expiration_date';
3715: l_lot_from := '
3716: , mtl_lot_numbers lot';
3717: l_lot_where := '
3718: AND x.organization_id = lot.organization_id (+)
3719: AND x.inventory_item_id = lot.inventory_item_id (+)
3720: AND x.lot_number = lot.lot_number (+) ';