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_RENT_CALC_PKG dependencies on PN_VAR_TRX_DETAILS_ALL

Line 452: pn_var_trx_details_all

448: NVL(SUM(fy_pr_grp_vol_start),0) AS bkpt_start
449: ,NVL(SUM(fy_pr_grp_vol_end),0) AS bkpt_end
450: ,bkpt_rate
451: FROM
452: pn_var_trx_details_all
453: WHERE
454: trx_header_id IN
455: (SELECT
456: trx_header_id

Line 506: pn_var_trx_details_all

502: NVL(SUM(ly_pr_grp_vol_start),0) AS bkpt_start
503: ,NVL(SUM(ly_pr_grp_vol_end),0) AS bkpt_end
504: ,bkpt_rate
505: FROM
506: pn_var_trx_details_all
507: WHERE
508: trx_header_id IN
509: (SELECT
510: trx_header_id

Line 5584: pn_var_trx_details_all dtls

5580: dtls.blended_period_vol_end,
5581: hdr.prorated_group_sales_for,
5582: hdr.ytd_sales_for
5583: FROM pn_var_trx_headers_all hdr,
5584: pn_var_trx_details_all dtls
5585: WHERE hdr.trx_header_id=dtls.trx_header_id
5586: AND dtls.trx_detail_id = detail_id;
5587:
5588: BEGIN

Line 6770: pn_var_trx_details_all

6766: NVL(SUM(ly_pr_grp_vol_start),0) AS bkpt_start
6767: ,NVL(SUM(ly_pr_grp_vol_end),0) AS bkpt_end
6768: ,bkpt_rate
6769: FROM
6770: pn_var_trx_details_all
6771: WHERE
6772: trx_header_id IN
6773: (SELECT
6774: trx_header_id

Line 6827: pn_var_trx_details_all

6823: NVL(SUM(fy_pr_grp_vol_start),0) AS bkpt_start
6824: ,NVL(SUM(fy_pr_grp_vol_end),0) AS bkpt_end
6825: ,bkpt_rate
6826: FROM
6827: pn_var_trx_details_all
6828: WHERE
6829: trx_header_id IN
6830: (SELECT
6831: trx_header_id

Line 6906: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr

6902: dtls.bkpt_rate,
6903: hdr.var_rent_id,
6904: hdr.period_id,
6905: hdr.line_item_group_id
6906: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr
6907: WHERE dtls.trx_detail_id = p_trx_detail_id
6908: AND hdr.trx_header_id = dtls.trx_header_id;
6909:
6910: BEGIN

Line 7014: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr

7010: dtls.bkpt_rate,
7011: hdr.var_rent_id,
7012: hdr.period_id,
7013: hdr.line_item_group_id
7014: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr
7015: WHERE dtls.trx_detail_id = p_trx_detail_id
7016: AND hdr.trx_header_id = dtls.trx_header_id;
7017:
7018: BEGIN

Line 7146: pn_var_trx_details_all dtls

7142: hdr.ytd_sales,
7143: hdr.prorated_group_deductions,
7144: hdr.ytd_deductions
7145: FROM pn_var_trx_headers_all hdr,
7146: pn_var_trx_details_all dtls
7147: WHERE hdr.trx_header_id=dtls.trx_header_id
7148: AND dtls.trx_detail_id = detail_id;
7149:
7150: BEGIN

Line 7418: pn_var_trx_details_all dtls

7414: hdr.line_item_group_id,
7415: hdr.period_id,
7416: hdr.var_rent_id
7417: FROM pn_var_trx_headers_all hdr,
7418: pn_var_trx_details_all dtls
7419: WHERE hdr.trx_header_id = dtls.trx_header_id
7420: AND dtls.trx_detail_id = p_trx_detail_id;
7421:
7422: l_sales NUMBER := 0;

Line 7529: pn_var_trx_details_all dtls

7525: hdr.ytd_deductions,
7526: hdr.period_id,
7527: hdr.var_rent_id
7528: FROM pn_var_trx_headers_all hdr,
7529: pn_var_trx_details_all dtls
7530: WHERE hdr.trx_header_id = dtls.trx_header_id
7531: AND dtls.trx_detail_id = p_trx_detail_id;
7532:
7533: l_sales NUMBER := 0;

Line 7661: pn_var_trx_details_all dtls

7657: hdr.line_item_group_id,
7658: hdr.period_id,
7659: hdr.var_rent_id
7660: FROM pn_var_trx_headers_all hdr,
7661: pn_var_trx_details_all dtls
7662: WHERE hdr.trx_header_id = dtls.trx_header_id
7663: AND dtls.trx_detail_id = p_trx_detail_id;
7664:
7665: l_first_period VARCHAR2(1) := 'N';

Line 7770: pn_var_trx_details_all dtls

7766: hdr.trx_header_id,
7767: hdr.calc_prd_start_date,
7768: hdr.line_item_id
7769: FROM pn_var_trx_headers_all hdr,
7770: pn_var_trx_details_all dtls
7771: WHERE hdr.trx_header_id = dtls.trx_header_id
7772: AND dtls.trx_detail_id = p_trx_detail_id;
7773:
7774: -- Get the details of

Line 7892: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr

7888: dtls.bkpt_rate,
7889: hdr.var_rent_id,
7890: hdr.period_id,
7891: hdr.line_item_group_id
7892: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr
7893: WHERE dtls.trx_detail_id = p_trx_detail_id
7894: AND hdr.trx_header_id = dtls.trx_header_id;
7895:
7896: CURSOR blended_prd_csr (p_period_id IN NUMBER, p_bkpt_rate IN NUMBER) IS

Line 7898: FROM pn_var_trx_details_all dtls,

7894: AND hdr.trx_header_id = dtls.trx_header_id;
7895:
7896: CURSOR blended_prd_csr (p_period_id IN NUMBER, p_bkpt_rate IN NUMBER) IS
7897: SELECT sum(dtls.prorated_grp_vol_start) bkpt_start
7898: FROM pn_var_trx_details_all dtls,
7899: pn_var_trx_headers_all hdr
7900: WHERE hdr.trx_header_id = dtls.trx_header_id
7901: AND hdr.period_id = p_period_id
7902: AND dtls.bkpt_rate = p_bkpt_rate;

Line 8038: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr

8034: dtls.bkpt_rate,
8035: hdr.var_rent_id,
8036: hdr.period_id,
8037: hdr.line_item_group_id
8038: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr
8039: WHERE dtls.trx_detail_id = p_trx_detail_id
8040: AND hdr.trx_header_id = dtls.trx_header_id;
8041:
8042: CURSOR blended_prd_csr (p_period_id IN NUMBER, p_bkpt_rate IN NUMBER) IS

Line 8045: FROM pn_var_trx_details_all dtls,

8041:
8042: CURSOR blended_prd_csr (p_period_id IN NUMBER, p_bkpt_rate IN NUMBER) IS
8043: SELECT sum(prorated_grp_vol_start) bkpt_start,
8044: sum(prorated_grp_vol_end) bkpt_end
8045: FROM pn_var_trx_details_all dtls,
8046: pn_var_trx_headers_all hdr
8047: WHERE hdr.trx_header_id = dtls.trx_header_id
8048: AND hdr.period_id = p_period_id
8049: AND dtls.bkpt_rate = p_bkpt_rate;

Line 8181: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr,

8177: bkpts.group_bkpt_vol_start,
8178: hdr.var_rent_id,
8179: hdr.period_id,
8180: hdr.line_item_group_id
8181: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr,
8182: pn_var_bkpts_det_all bkpts
8183: WHERE dtls.trx_detail_id = p_trx_detail_id
8184: AND hdr.trx_header_id = dtls.trx_header_id
8185: AND bkpts.bkpt_detail_id = dtls.bkpt_detail_id;

Line 8292: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr,

8288: bkpts.group_bkpt_vol_end,
8289: hdr.var_rent_id,
8290: hdr.period_id,
8291: hdr.line_item_group_id
8292: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr,
8293: pn_var_bkpts_det_all bkpts
8294: WHERE dtls.trx_detail_id = p_trx_detail_id
8295: AND hdr.trx_header_id = dtls.trx_header_id
8296: AND bkpts.bkpt_detail_id = dtls.bkpt_detail_id;

Line 8394: pn_var_trx_details_all dtls

8390: hdr.first_yr_rent,
8391: hdr.period_id,
8392: hdr.var_rent_id
8393: FROM pn_var_trx_headers_all hdr,
8394: pn_var_trx_details_all dtls
8395: WHERE hdr.trx_header_id = dtls.trx_header_id
8396: AND dtls.trx_detail_id = p_trx_detail_id;
8397:
8398: -- Get the details of

Line 8494: pn_var_trx_details_all dtls

8490: hdr.first_yr_rent,
8491: hdr.period_id,
8492: hdr.var_rent_id
8493: FROM pn_var_trx_headers_all hdr,
8494: pn_var_trx_details_all dtls
8495: WHERE hdr.trx_header_id = dtls.trx_header_id
8496: AND dtls.trx_detail_id = p_trx_detail_id;
8497:
8498: -- Get the details of

Line 8745: pn_var_trx_details_all dtls

8741: ,dtls.ytd_group_vol_end AS trueup_bkpt_vol_end
8742: ,hdr.ytd_sales AS trueup_volume
8743: ,hdr.ytd_deductions AS deductions
8744: FROM pn_var_trx_headers_all hdr,
8745: pn_var_trx_details_all dtls
8746: WHERE dtls.trx_detail_id = p_trx_detail_id
8747: AND dtls.bkpt_rate = p_rate
8748: AND dtls.trx_header_id = hdr.trx_header_id;
8749:

Line 10788: FROM pn_var_trx_details_all dtls,

10784:
10785: CURSOR get_blended_bkpt_csr(p_var_rent_id IN NUMBER) IS
10786: SELECT sum(pr_grp_blended_vol_start) bkpt_start,
10787: sum(pr_grp_blended_vol_end) bkpt_end
10788: FROM pn_var_trx_details_all dtls,
10789: pn_var_trx_headers_all hdr
10790: WHERE var_rent_id = p_var_rent_id
10791: AND hdr.trx_header_id = dtls.trx_header_id
10792: AND dtls.bkpt_rate = p_bkpt_rate