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_TRANSACTION_LOTS_TEMP

Line 492: -- created in the mtl_transaction_lots_temp table.

488:
489: IF p_is_lot_control THEN
490: -- here we assume that even there is only one lot number
491: -- involved in a transaction, a child record would be
492: -- created in the mtl_transaction_lots_temp table.
493: l_pending_txn_stmt := '
494: UNION ALL
495: -- pending transactions and picking suggestions
496: -- in mmtt with lot number in mmtt

Line 604: , mtl_transaction_lots_temp mtlt

600: , mmtt.planning_organization_id planning_organization_id
601: , mmtt.owning_organization_id owning_organization_id
602: FROM
603: mtl_material_transactions_temp mmtt
604: , mtl_transaction_lots_temp mtlt
605: WHERE
606: mmtt.posting_flag = ''Y''
607: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
608: AND mmtt.lot_number IS NULL

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 2423: FROM mtl_material_transactions_temp mmtt,mtl_transaction_lots_temp mtlt

2419: , SUM(Decode(mmtt.transaction_action_id, 1, -1, 2, -1, 28, -1, 3, -1,
2420: Sign(mtlt.secondary_quantity)) * Abs( NVL(mtlt.secondary_quantity, 0) ))
2421: INTO l_mmtt_qty_src
2422: , l_mmtt_sqty_src
2423: FROM mtl_material_transactions_temp mmtt,mtl_transaction_lots_temp mtlt
2424: WHERE mmtt.organization_id = p_org_id
2425: AND mmtt.inventory_item_id = p_item_id
2426: AND mmtt.posting_flag = 'Y'
2427: AND mtlt.transaction_temp_id = mmtt.transaction_temp_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 2468: FROM mtl_material_transactions_temp mmtt,mtl_transaction_lots_temp mtlt

2464: SELECT SUM(Abs(mtlt.primary_quantity))
2465: , SUM(Abs( NVL(mtlt.secondary_quantity, 0) ))
2466: INTO l_mmtt_qty_dest
2467: , l_mmtt_sqty_dest
2468: FROM mtl_material_transactions_temp mmtt,mtl_transaction_lots_temp mtlt
2469: WHERE decode(mmtt.transaction_action_id,3,
2470: mmtt.transfer_organization,mmtt.organization_id) = p_org_id
2471: AND mmtt.inventory_item_id = p_item_id
2472: AND mmtt.posting_flag = 'Y'

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 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 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 3285: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

3281:
3282: SELECT SUM(Decode(mmtt.transaction_action_id, 1, -1, 2, -1, 28, -1, 3, -1,
3283: Sign(mmtt.primary_quantity)) * Abs( mmtt.primary_quantity ))
3284: INTO l_mmtt_qty_src
3285: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
3286: WHERE mmtt.organization_id = p_org_id
3287: AND mmtt.inventory_item_id = p_item_id
3288: AND mmtt.posting_flag = 'Y'
3289: AND mmtt.subinventory_code IS NOT NULL

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 3318: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

3314:
3315: SELECT SUM(Decode(mmtt.transaction_action_id, 1, -1, 2, -1, 28, -1, 3, -1,
3316: Sign(mmtt.primary_quantity)) * Abs( mmtt.primary_quantity ))
3317: INTO l_mmtt_qty_src
3318: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
3319: WHERE mmtt.organization_id = p_org_id
3320: AND mmtt.inventory_item_id = p_item_id
3321: AND mmtt.posting_flag = 'Y'
3322: AND mmtt.subinventory_code IS NOT NULL

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 3357: FROM mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt

3353: IF (p_onhand_source = g_atpable_only) THEN
3354:
3355: SELECT SUM(Abs(mmtt.primary_quantity))
3356: INTO l_mmtt_qty_dest
3357: FROM mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt
3358: WHERE decode(mmtt.transaction_action_id,3,
3359: mmtt.transfer_organization,mmtt.organization_id) = p_org_id
3360: AND mmtt.inventory_item_id = p_item_id
3361: AND mmtt.posting_flag = 'Y'

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 3400: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

3396: ELSE
3397:
3398: SELECT SUM(Abs(mmtt.primary_quantity))
3399: INTO l_mmtt_qty_dest
3400: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
3401: WHERE decode(mmtt.transaction_action_id,3,
3402: mmtt.transfer_organization,mmtt.organization_id) = p_org_id
3403: AND mmtt.inventory_item_id = p_item_id
3404: AND mmtt.posting_flag = 'Y'

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(+)