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_SECONDARY_INVENTORIES

Line 804: , mtl_secondary_inventories sub '

800: , x.subinventory_code, x.locator_id
801: , x.quantity_type, x.cost_group_id, x.containerized
802: , x.planning_organization_id, x.owning_organization_id
803: ) x
804: , mtl_secondary_inventories sub '
805: || l_lot_from || '
806: WHERE
807: x.organization_id = sub.organization_id (+)
808: AND x.subinventory_code = sub.secondary_inventory_name (+) '

Line 1179: FROM mtl_secondary_inventories

1175: l_reservable_type NUMBER;
1176: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1177: BEGIN
1178: SELECT reservable_type INTO l_reservable_type
1179: FROM mtl_secondary_inventories
1180: WHERE organization_id = p_organization_id
1181: AND secondary_inventory_name = p_subinventory_code;
1182: IF (l_reservable_type = 1) THEN
1183: x_is_reservable_sub := TRUE;

Line 1224: FROM mtl_secondary_inventories

1220:
1221: CURSOR is_RSV_subInv( org_id IN NUMBER
1222: , subinv IN VARCHAR2) IS
1223: SELECT reservable_type
1224: FROM mtl_secondary_inventories
1225: WHERE organization_id = org_id
1226: AND secondary_inventory_name = subinv;
1227:
1228: --SELECT TO_NUMBER(NVL(attribute1, '0'))

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 2320: AND EXISTS (SELECT 'x' FROM mtl_secondary_inventories msi

2316: AND mmtt.posting_flag = 'Y'
2317: AND mmtt.subinventory_code IS NOT NULL
2318: AND Nvl(mmtt.transaction_status,0) <> 2
2319: AND mmtt.transaction_action_id NOT IN (24,30)
2320: AND EXISTS (SELECT 'x' FROM mtl_secondary_inventories msi
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

Line 2367: SELECT 'x' FROM mtl_secondary_inventories msi

2363: (
2364: mmtt.transfer_subinventory IS NOT NULL
2365: AND EXISTS
2366: (
2367: SELECT 'x' FROM mtl_secondary_inventories msi
2368: WHERE msi.organization_id = decode(mmtt.transaction_action_id,
2369: 3, mmtt.transfer_organization,mmtt.organization_id)
2370: AND msi.secondary_inventory_name = mmtt.transfer_subinventory
2371: AND msi.availability_type = decode(p_include_nonnet,1,msi.availability_type,1)

Line 2432: AND EXISTS (SELECT 'x' FROM mtl_secondary_inventories msi

2428: AND mmtt.subinventory_code IS NOT NULL
2429: AND mmtt.subinventory_code IS NOT NULL
2430: AND Nvl(mmtt.transaction_status,0) <> 2
2431: AND mmtt.transaction_action_id NOT IN (24,30)
2432: AND EXISTS (SELECT 'x' FROM mtl_secondary_inventories msi
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

Line 2484: SELECT 'x' FROM mtl_secondary_inventories msi

2480: (
2481: mmtt.transfer_subinventory IS NOT NULL
2482: AND EXISTS
2483: (
2484: SELECT 'x' FROM mtl_secondary_inventories msi
2485: WHERE msi.organization_id = decode(mmtt.transaction_action_id,
2486: 3, mmtt.transfer_organization,mmtt.organization_id)
2487: AND msi.secondary_inventory_name = mmtt.transfer_subinventory
2488: )

Line 2560: AND EXISTS (select 'x' from mtl_secondary_inventories msi

2556: AND mmtt.posting_flag = 'Y'
2557: AND mmtt.subinventory_code IS NOT NULL
2558: AND Nvl(mmtt.transaction_status,0) <> 2
2559: AND mmtt.transaction_action_id NOT IN (24,30)
2560: AND EXISTS (select 'x' from mtl_secondary_inventories msi
2561: WHERE msi.organization_id = mmtt.organization_id
2562: AND msi.secondary_inventory_name = mmtt.subinventory_code
2563: AND msi.availability_type = decode(p_include_nonnet,1,msi.availability_type,1))
2564: AND mmtt.planning_organization_id IS NULL

Line 2595: AND EXISTS (select 'x' from mtl_secondary_inventories msi

2591: AND Nvl(mmtt.transaction_status,0) <> 2
2592: AND mmtt.transaction_action_id in (2,28,3)
2593: AND ((mmtt.transfer_subinventory IS NULL) OR
2594: (mmtt.transfer_subinventory IS NOT NULL
2595: AND EXISTS (select 'x' from mtl_secondary_inventories msi
2596: WHERE msi.organization_id = decode(mmtt.transaction_action_id,
2597: 3, mmtt.transfer_organization,mmtt.organization_id)
2598: AND msi.secondary_inventory_name = mmtt.transfer_subinventory
2599: AND msi.availability_type = decode(p_include_nonnet,1,msi.availability_type,1))))

Line 2638: AND EXISTS (select 'x' from mtl_secondary_inventories msi

2634: AND mmtt.posting_flag = 'Y'
2635: AND mmtt.subinventory_code IS NOT NULL
2636: AND Nvl(mmtt.transaction_status,0) <> 2
2637: AND mmtt.transaction_action_id NOT IN (24,30)
2638: AND EXISTS (select 'x' from mtl_secondary_inventories msi
2639: WHERE msi.organization_id = mmtt.organization_id
2640: AND msi.secondary_inventory_name = mmtt.subinventory_code)
2641: AND mmtt.planning_organization_id IS NULL
2642:

Line 2678: AND EXISTS (select 'x' from mtl_secondary_inventories msi

2674: AND Nvl(mmtt.transaction_status,0) <> 2
2675: AND mmtt.transaction_action_id in (2,28,3)
2676: AND ((mmtt.transfer_subinventory IS NULL) OR
2677: (mmtt.transfer_subinventory IS NOT NULL
2678: AND EXISTS (select 'x' from mtl_secondary_inventories msi
2679: WHERE msi.organization_id = decode(mmtt.transaction_action_id,
2680: 3, mmtt.transfer_organization,mmtt.organization_id)
2681: AND msi.secondary_inventory_name = mmtt.transfer_subinventory)))
2682: AND mmtt.planning_organization_id IS NULL

Line 2965: AND EXISTS (select 'x' from mtl_secondary_inventories msi

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
2967: msi.secondary_inventory_name = moq.subinventory_code
2968: AND nvl(msi.inventory_atp_code,1) = 1)
2969: AND moq.organization_id = nvl(moq.planning_organization_id, moq.organization_id)

Line 2982: (select 'x' from mtl_secondary_inventories msi

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
2983: WHERE msi.organization_id = moq.organization_id and
2984: msi.secondary_inventory_name = moq.subinventory_code
2985: AND msi.availability_type = decode(p_onhand_source,g_all_subs,msi.availability_type,1))
2986: AND moq.organization_id = nvl(moq.planning_organization_id, moq.organization_id)

Line 3012: AND EXISTS (select 'x' from mtl_secondary_inventories msi

3008: AND mmtt.posting_flag = 'Y'
3009: AND mmtt.subinventory_code IS NOT NULL
3010: AND Nvl(mmtt.transaction_status,0) <> 2
3011: AND mmtt.transaction_action_id NOT IN (24,30)
3012: AND EXISTS (select 'x' from mtl_secondary_inventories msi
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

Line 3038: (select 'x' from mtl_secondary_inventories msi

3034: AND mmtt.subinventory_code IS NOT NULL
3035: AND Nvl(mmtt.transaction_status,0) <> 2
3036: AND mmtt.transaction_action_id NOT IN (24,30)
3037: AND EXISTS
3038: (select 'x' from mtl_secondary_inventories msi
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

Line 3071: (select 'x' from mtl_secondary_inventories msi

3067: AND mmtt.transaction_action_id in (2,28,3)
3068: AND ((mmtt.transfer_subinventory IS NULL) OR
3069: (mmtt.transfer_subinventory IS NOT NULL
3070: AND EXISTS
3071: (select 'x' from mtl_secondary_inventories msi
3072: WHERE msi.organization_id = decode(mmtt.transaction_action_id,
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)))

Line 3099: AND EXISTS (select 'x' from mtl_secondary_inventories msi

3095: AND Nvl(mmtt.transaction_status,0) <> 2
3096: AND mmtt.transaction_action_id in (2,28,3)
3097: AND ((mmtt.transfer_subinventory IS NULL) OR
3098: (mmtt.transfer_subinventory IS NOT NULL
3099: AND EXISTS (select 'x' from mtl_secondary_inventories msi
3100: WHERE msi.organization_id = decode(mmtt.transaction_action_id,
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))))

Line 3133: AND EXISTS (select 'x' from mtl_secondary_inventories msi

3129: AND mmtt.posting_flag = 'Y'
3130: AND mmtt.subinventory_code IS NOT NULL
3131: AND Nvl(mmtt.transaction_status,0) <> 2
3132: AND mmtt.transaction_action_id NOT IN (24,30)
3133: AND EXISTS (select 'x' from mtl_secondary_inventories msi
3134: WHERE msi.organization_id = mmtt.organization_id
3135: AND msi.secondary_inventory_name = mmtt.subinventory_code
3136: AND nvl(msi.inventory_atp_code,1) = 1)
3137: AND mmtt.planning_organization_id IS NULL

Line 3152: AND EXISTS (select 'x' from mtl_secondary_inventories msi

3148: AND mmtt.posting_flag = 'Y'
3149: AND mmtt.subinventory_code IS NOT NULL
3150: AND Nvl(mmtt.transaction_status,0) <> 2
3151: AND mmtt.transaction_action_id NOT IN (24,30)
3152: AND EXISTS (select 'x' from mtl_secondary_inventories msi
3153: WHERE msi.organization_id = mmtt.organization_id
3154: AND msi.secondary_inventory_name = mmtt.subinventory_code
3155: AND msi.availability_type = decode(p_onhand_source,g_all_subs,msi.availability_type,1))
3156: AND mmtt.planning_organization_id IS NULL

Line 3178: AND EXISTS (select 'x' from mtl_secondary_inventories msi

3174: AND Nvl(mmtt.transaction_status,0) <> 2
3175: AND mmtt.transaction_action_id in (2,28,3)
3176: AND ((mmtt.transfer_subinventory IS NULL) OR
3177: (mmtt.transfer_subinventory IS NOT NULL
3178: AND EXISTS (select 'x' from mtl_secondary_inventories msi
3179: WHERE msi.organization_id = decode(mmtt.transaction_action_id,
3180: 3, mmtt.transfer_organization,mmtt.organization_id)
3181: AND msi.secondary_inventory_name = mmtt.transfer_subinventory
3182: AND nvl(msi.inventory_atp_code,1) = 1)))

Line 3199: AND EXISTS (select 'x' from mtl_secondary_inventories msi

3195: AND Nvl(mmtt.transaction_status,0) <> 2
3196: AND mmtt.transaction_action_id in (2,28,3)
3197: AND ((mmtt.transfer_subinventory IS NULL) OR
3198: (mmtt.transfer_subinventory IS NOT NULL
3199: AND EXISTS (select 'x' from mtl_secondary_inventories msi
3200: WHERE msi.organization_id = decode(mmtt.transaction_action_id,
3201: 3, mmtt.transfer_organization,mmtt.organization_id)
3202: AND msi.secondary_inventory_name = mmtt.transfer_subinventory
3203: AND msi.availability_type = decode(p_onhand_source,g_all_subs,msi.availability_type,1))))

Line 3227: AND EXISTS (select 'x' from mtl_secondary_inventories msi

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
3229: msi.secondary_inventory_name = moq.subinventory_code
3230: )
3231: AND moq.organization_id = nvl(moq.planning_organization_id, moq.organization_id)

Line 3253: (select 'x' from mtl_secondary_inventories msi

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
3254: WHERE msi.organization_id = moq.organization_id and
3255: msi.secondary_inventory_name = moq.subinventory_code)
3256: AND moq.organization_id = nvl(moq.planning_organization_id, moq.organization_id)
3257: AND moq.lot_number = mln.lot_number(+)

Line 3293: AND EXISTS (select 'x' from mtl_secondary_inventories msi

3289: AND mmtt.subinventory_code IS NOT NULL
3290: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
3291: AND Nvl(mmtt.transaction_status,0) <> 2
3292: AND mmtt.transaction_action_id NOT IN (24,30)
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

Line 3327: (select 'x' from mtl_secondary_inventories msi

3323: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
3324: AND Nvl(mmtt.transaction_status,0) <> 2
3325: AND mmtt.transaction_action_id NOT IN (24,30)
3326: AND EXISTS
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

Line 3368: (select 'x' from mtl_secondary_inventories msi

3364: AND mmtt.transaction_action_id in (2,28,3)
3365: AND ((mmtt.transfer_subinventory IS NULL) OR
3366: (mmtt.transfer_subinventory IS NOT NULL
3367: AND EXISTS
3368: (select 'x' from mtl_secondary_inventories msi
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

Line 3410: AND EXISTS (select 'x' from mtl_secondary_inventories msi

3406: AND Nvl(mmtt.transaction_status,0) <> 2
3407: AND mmtt.transaction_action_id in (2,28,3)
3408: AND ((mmtt.transfer_subinventory IS NULL) OR
3409: (mmtt.transfer_subinventory IS NOT NULL
3410: AND EXISTS (select 'x' from mtl_secondary_inventories msi
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

Line 3457: AND EXISTS (select 'x' from mtl_secondary_inventories msi

3453: AND mmtt.posting_flag = 'Y'
3454: AND mmtt.subinventory_code IS NOT NULL
3455: AND Nvl(mmtt.transaction_status,0) <> 2
3456: AND mmtt.transaction_action_id NOT IN (24,30)
3457: AND EXISTS (select 'x' from mtl_secondary_inventories msi
3458: WHERE msi.organization_id = mmtt.organization_id
3459: AND msi.secondary_inventory_name = mmtt.subinventory_code)
3460: AND mmtt.planning_organization_id IS NULL
3461: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms

Line 3483: AND EXISTS (select 'x' from mtl_secondary_inventories msi

3479: AND mmtt.posting_flag = 'Y'
3480: AND mmtt.subinventory_code IS NOT NULL
3481: AND Nvl(mmtt.transaction_status,0) <> 2
3482: AND mmtt.transaction_action_id NOT IN (24,30)
3483: AND EXISTS (select 'x' from mtl_secondary_inventories msi
3484: WHERE msi.organization_id = mmtt.organization_id
3485: AND msi.secondary_inventory_name = mmtt.subinventory_code)
3486: AND mmtt.planning_organization_id IS NULL
3487: AND EXISTS (SELECT 'x' FROM mtl_material_statuses mms

Line 3516: AND EXISTS (select 'x' from mtl_secondary_inventories msi

3512: AND Nvl(mmtt.transaction_status,0) <> 2
3513: AND mmtt.transaction_action_id in (2,28,3)
3514: AND ((mmtt.transfer_subinventory IS NULL) OR
3515: (mmtt.transfer_subinventory IS NOT NULL
3516: AND EXISTS (select 'x' from mtl_secondary_inventories msi
3517: WHERE msi.organization_id = decode(mmtt.transaction_action_id,
3518: 3, mmtt.transfer_organization,mmtt.organization_id)
3519: AND msi.secondary_inventory_name = mmtt.transfer_subinventory)))
3520: AND mmtt.planning_organization_id IS NULL

Line 3550: AND EXISTS (select 'x' from mtl_secondary_inventories msi

3546: AND Nvl(mmtt.transaction_status,0) <> 2
3547: AND mmtt.transaction_action_id in (2,28,3)
3548: AND ((mmtt.transfer_subinventory IS NULL) OR
3549: (mmtt.transfer_subinventory IS NOT NULL
3550: AND EXISTS (select 'x' from mtl_secondary_inventories msi
3551: WHERE msi.organization_id = decode(mmtt.transaction_action_id,
3552: 3, mmtt.transfer_organization,mmtt.organization_id)
3553: AND msi.secondary_inventory_name = mmtt.transfer_subinventory)))
3554: AND mmtt.planning_organization_id IS NULL

Line 3795: , mtl_secondary_inventories sub '

3791: , x.subinventory_code, x.locator_id
3792: , x.quantity_type, x.cost_group_id, x.containerized
3793: , x.planning_organization_id, x.owning_organization_id
3794: ) x
3795: , mtl_secondary_inventories sub '
3796: || l_lot_from || '
3797: WHERE
3798: x.organization_id = sub.organization_id (+)
3799: AND x.subinventory_code = sub.secondary_inventory_name (+) '