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.PN_VAR_TRX_PKG dependencies on PN_VAR_VOL_HIST_ALL

Line 2909: pn_var_vol_hist_all sales

2905: ,p_grp_id IN NUMBER) IS
2906: SELECT
2907: SUM(actual_amount) AS calc_prd_actual_volume
2908: FROM
2909: pn_var_vol_hist_all sales
2910: WHERE
2911: sales.period_id = p_prd_id AND
2912: sales.line_item_id = p_line_id AND
2913: sales.grp_date_id = p_grp_id AND

Line 2927: pn_var_vol_hist_all sales

2923: sales.actual_amount
2924: ,sales.start_date
2925: ,sales.end_date
2926: FROM
2927: pn_var_vol_hist_all sales
2928: WHERE
2929: sales.period_id = p_prd_id AND
2930: sales.line_item_id = p_line_id AND
2931: sales.grp_date_id = p_grp_id AND

Line 3048: pn_var_vol_hist_all sales

3044: ,p_grp_id IN NUMBER) IS
3045: SELECT
3046: SUM(actual_amount) AS calc_prd_actual_volume
3047: FROM
3048: pn_var_vol_hist_all sales
3049: WHERE
3050: sales.period_id = p_prd_id AND
3051: sales.line_item_id = p_line_id AND
3052: sales.grp_date_id = p_grp_id AND

Line 3066: pn_var_vol_hist_all sales

3062: sales.actual_amount
3063: ,sales.start_date
3064: ,sales.end_date
3065: FROM
3066: pn_var_vol_hist_all sales
3067: WHERE
3068: sales.period_id = p_prd_id AND
3069: sales.line_item_id = p_line_id AND
3070: sales.grp_date_id = p_grp_id AND

Line 3921: pn_var_vol_hist_all sales

3917: ,p_grp_id IN NUMBER) IS
3918: SELECT
3919: SUM(forecasted_amount) AS calc_prd_forecasted_volume
3920: FROM
3921: pn_var_vol_hist_all sales
3922: WHERE
3923: sales.period_id = p_prd_id AND
3924: sales.line_item_id = p_line_id AND
3925: sales.grp_date_id = p_grp_id;

Line 3938: pn_var_vol_hist_all sales

3934: sales.forecasted_amount
3935: ,sales.start_date
3936: ,sales.end_date
3937: FROM
3938: pn_var_vol_hist_all sales
3939: WHERE
3940: sales.period_id = p_prd_id AND
3941: sales.line_item_id = p_line_id AND
3942: sales.grp_date_id = p_grp_id AND

Line 4058: pn_var_vol_hist_all sales

4054: ,p_grp_id IN NUMBER) IS
4055: SELECT
4056: SUM(forecasted_amount) AS calc_prd_forecasted_volume
4057: FROM
4058: pn_var_vol_hist_all sales
4059: WHERE
4060: sales.period_id = p_prd_id AND
4061: sales.line_item_id = p_line_id AND
4062: sales.grp_date_id = p_grp_id;

Line 4075: pn_var_vol_hist_all sales

4071: sales.forecasted_amount
4072: ,sales.start_date
4073: ,sales.end_date
4074: FROM
4075: pn_var_vol_hist_all sales
4076: WHERE
4077: sales.period_id = p_prd_id AND
4078: sales.line_item_id = p_line_id AND
4079: sales.grp_date_id = p_grp_id AND