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.CST_PAC_ITERATION_PROCESS_PVT dependencies on MTL_PARAMETERS

Line 3050: , mtl_parameters mp

3046: , l_txn_type txn_type
3047: , p_period_id pac_period_id
3048: FROM
3049: mtl_material_transactions mmt
3050: , mtl_parameters mp
3051: , cst_cost_group_assignments c1
3052: , cst_cost_group_assignments c2
3053: , cst_cost_groups ccg1
3054: , cst_cost_groups ccg2

Line 3117: , mtl_parameters mp

3113: , l_txn_type txn_type
3114: , p_period_id pac_period_id
3115: FROM
3116: mtl_material_transactions mmt
3117: , mtl_parameters mp
3118: , cst_cost_group_assignments c1
3119: , cst_cost_group_assignments c2
3120: , cst_cost_groups ccg1
3121: , cst_cost_groups ccg2

Line 3225: , mtl_parameters mp

3221: , l_txn_type txn_type
3222: , p_period_id pac_period_id
3223: FROM
3224: mtl_material_transactions mmt
3225: , mtl_parameters mp
3226: , mtl_parameters mptrans
3227: WHERE
3228: mmt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3229: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)

Line 3226: , mtl_parameters mptrans

3222: , p_period_id pac_period_id
3223: FROM
3224: mtl_material_transactions mmt
3225: , mtl_parameters mp
3226: , mtl_parameters mptrans
3227: WHERE
3228: mmt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3229: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
3230: AND nvl(mmt.owning_tp_type,2) = 2

Line 3304: , mtl_parameters mp1

3300: , l_txn_type txn_type
3301: , p_period_id pac_period_id
3302: FROM
3303: mtl_material_transactions mmt1
3304: , mtl_parameters mp1
3305: , mtl_parameters mptrans1
3306: WHERE
3307: mmt1.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3308: AND mmt1.organization_id = nvl(mmt1.owning_organization_id, mmt1.organization_id)

Line 3305: , mtl_parameters mptrans1

3301: , p_period_id pac_period_id
3302: FROM
3303: mtl_material_transactions mmt1
3304: , mtl_parameters mp1
3305: , mtl_parameters mptrans1
3306: WHERE
3307: mmt1.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3308: AND mmt1.organization_id = nvl(mmt1.owning_organization_id, mmt1.organization_id)
3309: AND nvl(mmt1.owning_tp_type,2) = 2

Line 3469: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp

3465: , 0
3466: , 0
3467: , 'N'
3468: , 'Y'
3469: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp
3470: WHERE ccit.cost_group_id = p_cost_group_id
3471: AND ccit.pac_period_id = p_period_id
3472: AND ccit.txn_type = 1
3473: AND mp.organization_id = ccit.transfer_organization_id

Line 3561: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp, cst_pac_low_level_codes cpllc

3557: , 0
3558: , 0
3559: , 'N'
3560: , 'Y'
3561: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp, cst_pac_low_level_codes cpllc
3562: WHERE ccit.cost_group_id = p_cost_group_id
3563: AND ccit.pac_period_id = p_period_id
3564: AND ccit.txn_type = 1
3565: AND mp.organization_id = ccit.transfer_organization_id