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_MATERIAL_TRANSACTIONS_TEMP

Line 545: mtl_material_transactions_temp mmtt

541: containerized
542: , planning_organization_id planning_organziation_id
543: , owning_organization_id owning_organization_id
544: FROM
545: mtl_material_transactions_temp mmtt
546: WHERE
547: mmtt.posting_flag = ''Y''
548: AND mmtt.lot_number IS NOT NULL
549: AND mmtt.subinventory_code IS NOT NULL

Line 603: mtl_material_transactions_temp mmtt

599: containerized
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

Line 667: mtl_material_transactions_temp mmtt

663: containerized
664: , mmtt.planning_organization_id planning_organization_id
665: , mmtt.owning_organization_id owning_organization_id
666: FROM
667: mtl_material_transactions_temp mmtt
668: WHERE
669: mmtt.posting_flag = ''Y''
670: AND mmtt.subinventory_code IS NOT NULL
671: AND (Nvl(mmtt.transaction_status,0) <> 2 OR -- pending txns

Line 2041: WHERE exists (select 1 from mtl_material_transactions_temp

2037:
2038: IF p_item_id IS NOT NULL AND p_lpn_id IS NULL THEN
2039:
2040: SELECT 1 INTO l_pending_txn_cnt FROM dual
2041: WHERE exists (select 1 from mtl_material_transactions_temp
2042: where organization_id = P_ORGANIZATION_ID
2043: and Nvl(transaction_status,1) in (1,3) --pending txn
2044: AND inventory_item_id = p_item_id
2045: and SUBINVENTORY_CODE = P_SUBINVENTORY_CODE

Line 2051: WHERE exists (select 1 from mtl_material_transactions_temp

2047:
2048: ELSIF p_lpn_id IS NOT NULL AND p_item_id IS NULL THEN
2049:
2050: SELECT 1 INTO l_pending_txn_cnt FROM dual
2051: WHERE exists (select 1 from mtl_material_transactions_temp
2052: where organization_id = P_ORGANIZATION_ID
2053: and Nvl(transaction_status,1) in (1,3) --pending txn
2054: AND ((transfer_lpn_id = p_lpn_id)
2055: OR (content_lpn_id = p_lpn_id)

Line 2067: WHERE exists (select 1 from mtl_material_transactions_temp

2063:
2064: IF p_item_id IS NOT NULL AND p_lpn_id IS NULL THEN
2065:
2066: SELECT 1 INTO l_pending_txn_cnt FROM dual
2067: WHERE exists (select 1 from mtl_material_transactions_temp
2068: where organization_id = P_ORGANIZATION_ID
2069: and Nvl(transaction_status,1) in (1,3) --pending txn
2070: AND inventory_item_id = p_item_id
2071: and SUBINVENTORY_CODE = P_SUBINVENTORY_CODE);

Line 2076: WHERE exists (select 1 from mtl_material_transactions_temp

2072:
2073: ELSIF p_lpn_id IS NOT NULL AND p_item_id IS NULL THEN
2074:
2075: SELECT 1 INTO l_pending_txn_cnt FROM dual
2076: WHERE exists (select 1 from mtl_material_transactions_temp
2077: where organization_id = P_ORGANIZATION_ID
2078: and Nvl(transaction_status,1) in (1,3) --pending txn
2079: AND ((transfer_lpn_id = p_lpn_id)
2080: OR (content_lpn_id = p_lpn_id)

Line 2107: -- MTL_MATERIAL_TRANSACTIONS_TEMP

2103: -- When it is called for Subinventory level query, it includes VMI quantity, because replenishment within the warehouse should not distinguish VMI stocks
2104: -- When it is called for Organization level query, it does not include VMI quantity, because relenishment for the whole warehouse should affect VMI stock
2105: -- The quantity is calculated with onhand quantity from
2106: -- MTL_ONHAND_QUANTITIES_DETAIL and pending transactions from
2107: -- MTL_MATERIAL_TRANSACTIONS_TEMP
2108: -- The quantities does not include suggestions
2109: -- Input Parameters
2110: -- P_INCLUDE_NONNET: Whether include non-nettable subinventories
2111: -- Values: 1 => Include non-nettable subinventories

Line 2313: FROM mtl_material_transactions_temp mmtt

2309: , SUM(Decode(mmtt.transaction_action_id, 1, -1, 2, -1, 28, -1, 3, -1,
2310: Sign(mmtt.secondary_transaction_quantity)) * Abs( NVL(mmtt.secondary_transaction_quantity, 0) ))
2311: INTO l_mmtt_qty_src
2312: , l_mmtt_sqty_src
2313: FROM mtl_material_transactions_temp mmtt
2314: WHERE mmtt.organization_id = p_org_id
2315: AND mmtt.inventory_item_id = p_item_id
2316: AND mmtt.posting_flag = 'Y'
2317: AND mmtt.subinventory_code IS NOT NULL

Line 2352: FROM mtl_material_transactions_temp mmtt

2348: SELECT SUM(Abs(mmtt.primary_quantity))
2349: , SUM(Abs( NVL(mmtt.secondary_transaction_quantity, 0) ))
2350: INTO l_mmtt_qty_dest
2351: , l_mmtt_sqty_dest
2352: FROM mtl_material_transactions_temp mmtt
2353: WHERE decode(mmtt.transaction_action_id,3,
2354: mmtt.transfer_organization,mmtt.organization_id) = p_org_id
2355: AND mmtt.inventory_item_id = p_item_id
2356: AND mmtt.posting_flag = 'Y'

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 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 2553: FROM mtl_material_transactions_temp mmtt

2549: , SUM(Decode(mmtt.transaction_action_id, 1, -1, 2, -1, 28, -1, 3, -1,
2550: Sign(mmtt.secondary_transaction_quantity)) * Abs( NVL(mmtt.secondary_transaction_quantity, 0) ))
2551: INTO l_mmtt_qty_src
2552: , l_mmtt_sqty_src
2553: FROM mtl_material_transactions_temp mmtt
2554: WHERE mmtt.organization_id = p_org_id
2555: AND mmtt.inventory_item_id = p_item_id
2556: AND mmtt.posting_flag = 'Y'
2557: AND mmtt.subinventory_code IS NOT NULL

Line 2586: FROM mtl_material_transactions_temp mmtt

2582: SELECT SUM(Abs(mmtt.primary_quantity))
2583: , SUM(Abs( NVL(mmtt.secondary_transaction_quantity, 0) ))
2584: INTO l_mmtt_qty_dest
2585: , l_mmtt_sqty_dest
2586: FROM mtl_material_transactions_temp mmtt
2587: WHERE decode(mmtt.transaction_action_id,3,
2588: mmtt.transfer_organization,mmtt.organization_id) = p_org_id
2589: AND mmtt.inventory_item_id = p_item_id
2590: AND mmtt.posting_flag = 'Y'

Line 2631: FROM mtl_material_transactions_temp mmtt

2627: , SUM(Decode(mmtt.transaction_action_id, 1, -1, 2, -1, 28, -1, 3, -1,
2628: Sign(mmtt.secondary_transaction_quantity)) * Abs( NVL(mmtt.secondary_transaction_quantity, 0) ))
2629: INTO l_mmtt_qty_src
2630: , l_mmtt_sqty_src
2631: FROM mtl_material_transactions_temp mmtt
2632: WHERE mmtt.organization_id = p_org_id
2633: AND mmtt.inventory_item_id = p_item_id
2634: AND mmtt.posting_flag = 'Y'
2635: AND mmtt.subinventory_code IS NOT NULL

Line 2669: FROM mtl_material_transactions_temp mmtt

2665: SELECT SUM(Abs(mmtt.primary_quantity))
2666: , SUM(Abs( NVL(mmtt.secondary_transaction_quantity, 0) ))
2667: INTO l_mmtt_qty_dest
2668: , l_mmtt_sqty_dest
2669: FROM mtl_material_transactions_temp mmtt
2670: WHERE decode(mmtt.transaction_action_id,3,
2671: mmtt.transfer_organization,mmtt.organization_id) = p_org_id
2672: AND mmtt.inventory_item_id = p_item_id
2673: AND mmtt.posting_flag = 'Y'

Line 2776: FROM mtl_material_transactions_temp mmtt

2772: , SUM(Decode(mmtt.transaction_action_id, 1, -1, 2, -1, 28, -1, 3, -1,
2773: Sign(mmtt.secondary_transaction_quantity)) * Abs( NVL(mmtt.secondary_transaction_quantity, 0) ))
2774: INTO l_mmtt_qty_src
2775: , l_mmtt_sqty_src
2776: FROM mtl_material_transactions_temp mmtt
2777: WHERE mmtt.organization_id = p_org_id
2778: AND mmtt.inventory_item_id = p_item_id
2779: AND mmtt.subinventory_code = p_subinv
2780: AND mmtt.posting_flag = 'Y'

Line 2799: FROM mtl_material_transactions_temp mmtt

2795: SELECT SUM(Abs(mmtt.primary_quantity))
2796: , SUM(Abs( NVL(mmtt.secondary_transaction_quantity, 0)))
2797: INTO l_mmtt_qty_dest
2798: , l_mmtt_sqty_dest
2799: FROM mtl_material_transactions_temp mmtt
2800: WHERE decode(mmtt.transaction_action_id,3,
2801: mmtt.transfer_organization,mmtt.organization_id) = p_org_id
2802: AND mmtt.inventory_item_id = p_item_id
2803: AND mmtt.transfer_subinventory = p_subinv

Line 2825: FROM mtl_material_transactions_temp mmtt

2821: , SUM(Decode(mmtt.transaction_action_id, 1, -1, 2, -1, 28, -1, 3, -1,
2822: Sign(mmtt.secondary_transaction_quantity)) * Abs( NVL(mmtt.secondary_transaction_quantity, 0) ))
2823: INTO l_mmtt_qty_src
2824: , l_mmtt_sqty_src
2825: FROM mtl_material_transactions_temp mmtt
2826: WHERE mmtt.organization_id = p_org_id
2827: AND mmtt.inventory_item_id = p_item_id
2828: AND mmtt.subinventory_code = p_subinv
2829: AND mmtt.posting_flag = 'Y'

Line 2842: FROM mtl_material_transactions_temp mmtt

2838: SELECT SUM(Abs(mmtt.primary_quantity))
2839: , SUM(Abs( NVL(mmtt.secondary_transaction_quantity, 0)))
2840: INTO l_mmtt_qty_dest
2841: , l_mmtt_sqty_dest
2842: FROM mtl_material_transactions_temp mmtt
2843: WHERE decode(mmtt.transaction_action_id,3,
2844: mmtt.transfer_organization,mmtt.organization_id) = p_org_id
2845: AND mmtt.inventory_item_id = p_item_id
2846: AND mmtt.transfer_subinventory = p_subinv

Line 2899: -- MTL_MATERIAL_TRANSACTIONS_TEMP

2895: -- This API returns the onhand quantity for planning purpose based on ATPable/Nettable/All subs
2896: -- When it is called for Organization level query, it does not include VMI quantity, because relenishment for the whole warehouse should affect VMI stock
2897: -- The quantity is calculated with onhand quantity from
2898: -- MTL_ONHAND_QUANTITIES_DETAIL and pending transactions from
2899: -- MTL_MATERIAL_TRANSACTIONS_TEMP
2900: -- The quantities does not include suggestions
2901: -- Input Parameters
2902: -- P_ONHAND_SOURCE: Whether include atpable/non-nettable subinventories
2903: -- Values: g_atpable_only => Only include atpable subinventories

Line 3005: FROM mtl_material_transactions_temp mmtt

3001:
3002: SELECT SUM(Decode(mmtt.transaction_action_id, 1, -1, 2, -1, 28, -1, 3, -1,
3003: Sign(mmtt.primary_quantity)) * Abs( mmtt.primary_quantity ))
3004: INTO l_mmtt_qty_src
3005: FROM mtl_material_transactions_temp mmtt
3006: WHERE mmtt.organization_id = p_org_id
3007: AND mmtt.inventory_item_id = p_item_id
3008: AND mmtt.posting_flag = 'Y'
3009: AND mmtt.subinventory_code IS NOT NULL

Line 3030: FROM mtl_material_transactions_temp mmtt

3026:
3027: SELECT SUM(Decode(mmtt.transaction_action_id, 1, -1, 2, -1, 28, -1, 3, -1,
3028: Sign(mmtt.primary_quantity)) * Abs( mmtt.primary_quantity ))
3029: INTO l_mmtt_qty_src
3030: FROM mtl_material_transactions_temp mmtt
3031: WHERE mmtt.organization_id = p_org_id
3032: AND mmtt.inventory_item_id = p_item_id
3033: AND mmtt.posting_flag = 'Y'
3034: AND mmtt.subinventory_code IS NOT NULL

Line 3061: FROM mtl_material_transactions_temp mmtt

3057: IF (p_onhand_source = g_atpable_only) THEN
3058:
3059: SELECT SUM(Abs(mmtt.primary_quantity))
3060: INTO l_mmtt_qty_dest
3061: FROM mtl_material_transactions_temp mmtt
3062: WHERE decode(mmtt.transaction_action_id,3,
3063: mmtt.transfer_organization,mmtt.organization_id) = p_org_id
3064: AND mmtt.inventory_item_id = p_item_id
3065: AND mmtt.posting_flag = 'Y'

Line 3090: FROM mtl_material_transactions_temp mmtt

3086: ELSE
3087:
3088: SELECT SUM(Abs(mmtt.primary_quantity))
3089: INTO l_mmtt_qty_dest
3090: FROM mtl_material_transactions_temp mmtt
3091: WHERE decode(mmtt.transaction_action_id,3,
3092: mmtt.transfer_organization,mmtt.organization_id) = p_org_id
3093: AND mmtt.inventory_item_id = p_item_id
3094: AND mmtt.posting_flag = 'Y'

Line 3126: FROM mtl_material_transactions_temp mmtt

3122:
3123: SELECT SUM(Decode(mmtt.transaction_action_id, 1, -1, 2, -1, 28, -1, 3, -1,
3124: Sign(mmtt.primary_quantity)) * Abs( mmtt.primary_quantity ))
3125: INTO l_mmtt_qty_src
3126: FROM mtl_material_transactions_temp mmtt
3127: WHERE mmtt.organization_id = p_org_id
3128: AND mmtt.inventory_item_id = p_item_id
3129: AND mmtt.posting_flag = 'Y'
3130: AND mmtt.subinventory_code IS NOT NULL

Line 3145: FROM mtl_material_transactions_temp mmtt

3141:
3142: SELECT SUM(Decode(mmtt.transaction_action_id, 1, -1, 2, -1, 28, -1, 3, -1,
3143: Sign(mmtt.primary_quantity)) * Abs( mmtt.primary_quantity ))
3144: INTO l_mmtt_qty_src
3145: FROM mtl_material_transactions_temp mmtt
3146: WHERE mmtt.organization_id = p_org_id
3147: AND mmtt.inventory_item_id = p_item_id
3148: AND mmtt.posting_flag = 'Y'
3149: AND mmtt.subinventory_code IS NOT NULL

Line 3169: FROM mtl_material_transactions_temp mmtt

3165: IF (p_onhand_source = g_atpable_only) THEN
3166:
3167: SELECT SUM(Abs(mmtt.primary_quantity))
3168: INTO l_mmtt_qty_dest
3169: FROM mtl_material_transactions_temp mmtt
3170: WHERE decode(mmtt.transaction_action_id,3,
3171: mmtt.transfer_organization,mmtt.organization_id) = p_org_id
3172: AND mmtt.inventory_item_id = p_item_id
3173: AND mmtt.posting_flag = 'Y'

Line 3190: FROM mtl_material_transactions_temp mmtt

3186: ELSE
3187:
3188: SELECT SUM(Abs(mmtt.primary_quantity))
3189: INTO l_mmtt_qty_dest
3190: FROM mtl_material_transactions_temp mmtt
3191: WHERE decode(mmtt.transaction_action_id,3,
3192: mmtt.transfer_organization,mmtt.organization_id) = p_org_id
3193: AND mmtt.inventory_item_id = p_item_id
3194: AND mmtt.posting_flag = 'Y'

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 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 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 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 3450: FROM mtl_material_transactions_temp mmtt

3446:
3447: SELECT SUM(Decode(mmtt.transaction_action_id, 1, -1, 2, -1, 28, -1, 3, -1,
3448: Sign(mmtt.primary_quantity)) * Abs( mmtt.primary_quantity ))
3449: INTO l_mmtt_qty_src
3450: FROM mtl_material_transactions_temp mmtt
3451: WHERE mmtt.organization_id = p_org_id
3452: AND mmtt.inventory_item_id = p_item_id
3453: AND mmtt.posting_flag = 'Y'
3454: AND mmtt.subinventory_code IS NOT NULL

Line 3476: FROM mtl_material_transactions_temp mmtt

3472:
3473: SELECT SUM(Decode(mmtt.transaction_action_id, 1, -1, 2, -1, 28, -1, 3, -1,
3474: Sign(mmtt.primary_quantity)) * Abs( mmtt.primary_quantity ))
3475: INTO l_mmtt_qty_src
3476: FROM mtl_material_transactions_temp mmtt
3477: WHERE mmtt.organization_id = p_org_id
3478: AND mmtt.inventory_item_id = p_item_id
3479: AND mmtt.posting_flag = 'Y'
3480: AND mmtt.subinventory_code IS NOT NULL

Line 3507: FROM mtl_material_transactions_temp mmtt

3503: IF (p_onhand_source = g_atpable_only) THEN
3504:
3505: SELECT SUM(Abs(mmtt.primary_quantity))
3506: INTO l_mmtt_qty_dest
3507: FROM mtl_material_transactions_temp mmtt
3508: WHERE decode(mmtt.transaction_action_id,3,
3509: mmtt.transfer_organization,mmtt.organization_id) = p_org_id
3510: AND mmtt.inventory_item_id = p_item_id
3511: AND mmtt.posting_flag = 'Y'

Line 3541: FROM mtl_material_transactions_temp mmtt

3537: ELSE
3538:
3539: SELECT SUM(Abs(mmtt.primary_quantity))
3540: INTO l_mmtt_qty_dest
3541: FROM mtl_material_transactions_temp mmtt
3542: WHERE decode(mmtt.transaction_action_id,3,
3543: mmtt.transfer_organization,mmtt.organization_id) = p_org_id
3544: AND mmtt.inventory_item_id = p_item_id
3545: AND mmtt.posting_flag = 'Y'