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_TRUEUP_PKG dependencies on PN_VAR_RENT_SUMM_ALL

Line 218: pn_var_rent_summ_all

214: pnp_debug_pkg.log('l_billed_rent:'||l_billed_rent);
215: pnp_debug_pkg.log('trup_rent:'||trueup_rec.trueup_rent);
216:
217: UPDATE
218: pn_var_rent_summ_all
219: SET
220: trueup_var_rent = 0
221: WHERE
222: var_rent_id = p_var_rent_id AND

Line 227: pn_var_rent_summ_all

223: period_id = p_period_id AND
224: line_item_id = trueup_rec.line_item_id;
225:
226: UPDATE
227: pn_var_rent_summ_all
228: SET
229: trueup_var_rent = round((trueup_rec.trueup_rent - l_billed_rent), g_precision)
230: WHERE
231: var_rent_id = p_var_rent_id AND

Line 276: pn_var_rent_summ_all

272: MAX(invoice_date) AS trueup_invoice_date
273: ,NVL(SUM(tot_act_vol), 0) AS total_actual_sales
274: ,NVL(SUM(trueup_var_rent), 0) AS total_trueup_rent
275: FROM
276: pn_var_rent_summ_all
277: WHERE
278: var_rent_id = p_vr_id AND
279: period_id = p_prd_id AND
280: invoice_date <= p_new_termn_date;

Line 317: pn_var_rent_summ_all

313: SELECT
314: NVL(SUM(act_var_rent), 0) AS total_period_rent
315: ,NVL(SUM(trueup_var_rent), 0) AS total_trueup_rent
316: FROM
317: pn_var_rent_summ_all
318: WHERE
319: var_rent_id = p_vr_id AND
320: period_id = p_prd_id;
321:

Line 676: pn_var_rent_summ_all

672: SELECT
673: NULL as var_rent_inv_id
674: ,(SELECT NVL((SUM(act_var_rent) + NVL(SUM(trueup_var_rent), 0) - NVL(SUM(first_yr_rent), 0)), 0)
675: FROM
676: pn_var_rent_summ_all
677: WHERE
678: var_rent_id = ip_var_rent_id AND
679: period_id = ip_period_id
680: ) AS constr_actual_rent

Line 683: pn_var_rent_summ_all

679: period_id = ip_period_id
680: ) AS constr_actual_rent
681: ,(SELECT NVL((SUM(act_var_rent) + NVL(SUM(trueup_var_rent), 0) - NVL(SUM(first_yr_rent), 0)), 0)
682: FROM
683: pn_var_rent_summ_all
684: WHERE
685: var_rent_id = ip_var_rent_id AND
686: period_id = ip_period_id
687: ) AS true_up_amt

Line 691: pn_var_rent_summ_all summ,

687: ) AS true_up_amt
688: ,'N' true_up_exp_code
689: , invoice_date
690: FROM
691: pn_var_rent_summ_all summ,
692: pn_var_periods_all per,
693: pn_var_rents_all vr
694: WHERE
695: summ.period_id = per.period_id AND

Line 701: AND summ.group_date = (select max(group_date) from pn_var_rent_summ_all

697: (per.period_num <> 1 OR
698: vr.proration_rule NOT IN ('FY', 'FLY')) AND
699: summ.var_rent_id = ip_var_rent_id AND
700: summ.period_id = ip_period_id
701: AND summ.group_date = (select max(group_date) from pn_var_rent_summ_all
702: where period_id = ip_period_id)
703: AND G_IS_TU_CONC_FLAG = 'T'
704:
705: UNION ALL

Line 710: pn_var_rent_summ_all summ,

706: SELECT
707: NULL as var_rent_inv_id
708: ,(SELECT NVL(SUM(first_yr_rent), 0)
709: FROM
710: pn_var_rent_summ_all summ,
711: pn_var_periods_all per
712: WHERE
713: per.period_id = summ.period_id AND
714: summ.var_rent_id = ip_var_rent_id AND

Line 720: pn_var_rent_summ_all

716: )
717: +
718: (SELECT NVL(SUM(trueup_var_rent), 0)
719: FROM
720: pn_var_rent_summ_all
721: WHERE
722: var_rent_id = ip_var_rent_id AND
723: period_id = ip_period_id
724: )

Line 728: pn_var_rent_summ_all summ,

724: )
725: as const_t
726: ,(SELECT NVL(SUM(first_yr_rent), 0)
727: FROM
728: pn_var_rent_summ_all summ,
729: pn_var_periods_all per
730: WHERE
731: per.period_id = summ.period_id AND
732: summ.var_rent_id = ip_var_rent_id AND

Line 738: pn_var_rent_summ_all

734: )
735: +
736: (SELECT NVL(SUM(trueup_var_rent), 0)
737: FROM
738: pn_var_rent_summ_all
739: WHERE
740: var_rent_id = ip_var_rent_id AND
741: period_id = ip_period_id
742: )

Line 747: pn_var_rent_summ_all summ,

743: AS true_up_amt
744: ,'N' true_up_exp_code
745: , invoice_date
746: FROM
747: pn_var_rent_summ_all summ,
748: pn_var_periods_all per,
749: pn_var_rents_all vr
750: WHERE
751: summ.period_id = per.period_id AND

Line 757: AND summ.group_date = (select max(group_date) from pn_var_rent_summ_all

753: vr.proration_rule IN ('FY', 'FLY') AND
754: per.period_num = 1 AND
755: summ.var_rent_id = ip_var_rent_id AND
756: summ.period_id = ip_period_id
757: AND summ.group_date = (select max(group_date) from pn_var_rent_summ_all
758: where period_id = ip_period_id)
759: AND G_IS_TU_CONC_FLAG = 'T';
760:
761: /* get prev invoiced amount. */

Line 1473: pn_var_rent_summ_all

1469: UNION ALL
1470: SELECT
1471: (SELECT NVL(SUM(act_var_rent), 0)
1472: FROM
1473: pn_var_rent_summ_all
1474: WHERE
1475: var_rent_id = ip_var_rent_id AND
1476: period_id = ip_period_id
1477: ) AS actual_invoiced_amount

Line 1483: pn_var_rent_summ_all

1479: , null rec_abatement
1480: , null rec_abatement_override
1481: ,(SELECT NVL(SUM(act_var_rent), 0)
1482: FROM
1483: pn_var_rent_summ_all
1484: WHERE
1485: var_rent_id = ip_var_rent_id AND
1486: period_id = ip_period_id
1487: ) AS true_up_amt

Line 1489: FROM PN_VAR_RENT_SUMM_ALL

1485: var_rent_id = ip_var_rent_id AND
1486: period_id = ip_period_id
1487: ) AS true_up_amt
1488: ,NULL AS VAR_RENT_INV_ID
1489: FROM PN_VAR_RENT_SUMM_ALL
1490: WHERE ip_inv_id IS NULL
1491: AND var_rent_id = ip_var_rent_id
1492: AND period_id = ip_period_id
1493: AND group_date = (select max(group_date) from pn_var_rent_summ_all

Line 1493: AND group_date = (select max(group_date) from pn_var_rent_summ_all

1489: FROM PN_VAR_RENT_SUMM_ALL
1490: WHERE ip_inv_id IS NULL
1491: AND var_rent_id = ip_var_rent_id
1492: AND period_id = ip_period_id
1493: AND group_date = (select max(group_date) from pn_var_rent_summ_all
1494: where period_id = ip_period_id)
1495: AND G_IS_TU_CONC_FLAG = 'T';
1496:
1497:

Line 1888: pn_var_rent_summ_all

1884: , invoice_date
1885: , null var_rent_inv_id
1886: ,(SELECT NVL(SUM(act_var_rent), 0)
1887: FROM
1888: pn_var_rent_summ_all
1889: WHERE
1890: var_rent_id = ip_var_rent_id AND
1891: period_id = ip_period_id
1892: ) AS true_up_amt

Line 1893: FROM PN_VAR_RENT_SUMM_ALL

1889: WHERE
1890: var_rent_id = ip_var_rent_id AND
1891: period_id = ip_period_id
1892: ) AS true_up_amt
1893: FROM PN_VAR_RENT_SUMM_ALL
1894: WHERE ip_inv_id IS NULL
1895: AND var_rent_id = ip_var_rent_id
1896: AND period_id = ip_period_id
1897: AND group_date = (select max(group_date) from pn_var_rent_summ_all

Line 1897: AND group_date = (select max(group_date) from pn_var_rent_summ_all

1893: FROM PN_VAR_RENT_SUMM_ALL
1894: WHERE ip_inv_id IS NULL
1895: AND var_rent_id = ip_var_rent_id
1896: AND period_id = ip_period_id
1897: AND group_date = (select max(group_date) from pn_var_rent_summ_all
1898: where period_id = ip_period_id)
1899: AND G_IS_TU_CONC_FLAG = 'T';
1900:
1901: -- Get the details of rolling allowance

Line 2158: pn_var_rent_summ_all

2154: SELECT
2155: invoice_date
2156: ,(SELECT NVL(SUM(act_var_rent), 0)
2157: FROM
2158: pn_var_rent_summ_all
2159: WHERE
2160: var_rent_id = ip_var_rent_id AND
2161: period_id = ip_period_id
2162: ) AS true_up_amt

Line 2164: FROM PN_VAR_RENT_SUMM_ALL

2160: var_rent_id = ip_var_rent_id AND
2161: period_id = ip_period_id
2162: ) AS true_up_amt
2163: ,null var_rent_inv_id
2164: FROM PN_VAR_RENT_SUMM_ALL
2165: WHERE ip_inv_id IS NULL
2166: AND var_rent_id = ip_var_rent_id
2167: AND period_id = ip_period_id
2168: AND group_date = (select max(group_date) from pn_var_rent_summ_all

Line 2168: AND group_date = (select max(group_date) from pn_var_rent_summ_all

2164: FROM PN_VAR_RENT_SUMM_ALL
2165: WHERE ip_inv_id IS NULL
2166: AND var_rent_id = ip_var_rent_id
2167: AND period_id = ip_period_id
2168: AND group_date = (select max(group_date) from pn_var_rent_summ_all
2169: where period_id = ip_period_id)
2170: AND G_IS_TU_CONC_FLAG = 'T';
2171:
2172: --Get the last and first invoice dates for this period.