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 2904: , mtl_parameters mp

2900: , l_txn_type txn_type
2901: , p_period_id pac_period_id
2902: FROM
2903: mtl_material_transactions mmt
2904: , mtl_parameters mp
2905: , cst_cost_group_assignments c1
2906: , cst_cost_group_assignments c2
2907: WHERE
2908: mmt.transaction_date BETWEEN p_period_start_date AND p_period_end_date

Line 2966: , mtl_parameters mp

2962: , l_txn_type txn_type
2963: , p_period_id pac_period_id
2964: FROM
2965: mtl_material_transactions mmt
2966: , mtl_parameters mp
2967: , cst_cost_group_assignments c1
2968: , cst_cost_group_assignments c2
2969: WHERE
2970: mmt.transaction_date BETWEEN p_period_start_date AND p_period_end_date

Line 3069: , mtl_parameters mp

3065: , l_txn_type txn_type
3066: , p_period_id pac_period_id
3067: FROM
3068: mtl_material_transactions mmt
3069: , mtl_parameters mp
3070: , mtl_parameters mptrans
3071: WHERE
3072: mmt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3073: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)

Line 3070: , mtl_parameters mptrans

3066: , p_period_id pac_period_id
3067: FROM
3068: mtl_material_transactions mmt
3069: , mtl_parameters mp
3070: , mtl_parameters mptrans
3071: WHERE
3072: mmt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3073: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
3074: AND nvl(mmt.owning_tp_type,2) = 2

Line 3148: , mtl_parameters mp1

3144: , l_txn_type txn_type
3145: , p_period_id pac_period_id
3146: FROM
3147: mtl_material_transactions mmt1
3148: , mtl_parameters mp1
3149: , mtl_parameters mptrans1
3150: WHERE
3151: mmt1.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3152: AND mmt1.organization_id = nvl(mmt1.owning_organization_id, mmt1.organization_id)

Line 3149: , mtl_parameters mptrans1

3145: , p_period_id pac_period_id
3146: FROM
3147: mtl_material_transactions mmt1
3148: , mtl_parameters mp1
3149: , mtl_parameters mptrans1
3150: WHERE
3151: mmt1.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3152: AND mmt1.organization_id = nvl(mmt1.owning_organization_id, mmt1.organization_id)
3153: AND nvl(mmt1.owning_tp_type,2) = 2

Line 3313: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp

3309: , 0
3310: , 0
3311: , 'N'
3312: , 'Y'
3313: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp
3314: WHERE ccit.cost_group_id = p_cost_group_id
3315: AND ccit.pac_period_id = p_period_id
3316: AND ccit.txn_type = 1
3317: AND mp.organization_id = ccit.transfer_organization_id

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

3401: , 0
3402: , 0
3403: , 'N'
3404: , 'Y'
3405: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp, cst_pac_low_level_codes cpllc
3406: WHERE ccit.cost_group_id = p_cost_group_id
3407: AND ccit.pac_period_id = p_period_id
3408: AND ccit.txn_type = 1
3409: AND mp.organization_id = ccit.transfer_organization_id