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.

[Home] [Help]

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 5495: pn_var_trx_details_all dtls

5491: dtls.blended_period_vol_end,
5492: hdr.prorated_group_sales_for,
5493: hdr.ytd_sales_for
5494: FROM pn_var_trx_headers_all hdr,
5495: pn_var_trx_details_all dtls
5496: WHERE hdr.trx_header_id=dtls.trx_header_id
5497: AND dtls.trx_detail_id = detail_id;
5498:
5499: BEGIN

Line 6715: pn_var_trx_details_all

6711: NVL(SUM(ly_pr_grp_vol_start),0) AS bkpt_start
6712: ,NVL(SUM(ly_pr_grp_vol_end),0) AS bkpt_end
6713: ,bkpt_rate
6714: FROM
6715: pn_var_trx_details_all
6716: WHERE
6717: trx_header_id IN
6718: (SELECT
6719: trx_header_id

Line 6772: pn_var_trx_details_all

6768: NVL(SUM(fy_pr_grp_vol_start),0) AS bkpt_start
6769: ,NVL(SUM(fy_pr_grp_vol_end),0) AS bkpt_end
6770: ,bkpt_rate
6771: FROM
6772: pn_var_trx_details_all
6773: WHERE
6774: trx_header_id IN
6775: (SELECT
6776: trx_header_id

Line 6851: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr

6847: dtls.bkpt_rate,
6848: hdr.var_rent_id,
6849: hdr.period_id,
6850: hdr.line_item_group_id
6851: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr
6852: WHERE dtls.trx_detail_id = p_trx_detail_id
6853: AND hdr.trx_header_id = dtls.trx_header_id;
6854:
6855: BEGIN

Line 6959: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr

6955: dtls.bkpt_rate,
6956: hdr.var_rent_id,
6957: hdr.period_id,
6958: hdr.line_item_group_id
6959: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr
6960: WHERE dtls.trx_detail_id = p_trx_detail_id
6961: AND hdr.trx_header_id = dtls.trx_header_id;
6962:
6963: BEGIN

Line 7091: pn_var_trx_details_all dtls

7087: hdr.ytd_sales,
7088: hdr.prorated_group_deductions,
7089: hdr.ytd_deductions
7090: FROM pn_var_trx_headers_all hdr,
7091: pn_var_trx_details_all dtls
7092: WHERE hdr.trx_header_id=dtls.trx_header_id
7093: AND dtls.trx_detail_id = detail_id;
7094:
7095: BEGIN

Line 7363: pn_var_trx_details_all dtls

7359: hdr.line_item_group_id,
7360: hdr.period_id,
7361: hdr.var_rent_id
7362: FROM pn_var_trx_headers_all hdr,
7363: pn_var_trx_details_all dtls
7364: WHERE hdr.trx_header_id = dtls.trx_header_id
7365: AND dtls.trx_detail_id = p_trx_detail_id;
7366:
7367: l_sales NUMBER := 0;

Line 7474: pn_var_trx_details_all dtls

7470: hdr.ytd_deductions,
7471: hdr.period_id,
7472: hdr.var_rent_id
7473: FROM pn_var_trx_headers_all hdr,
7474: pn_var_trx_details_all dtls
7475: WHERE hdr.trx_header_id = dtls.trx_header_id
7476: AND dtls.trx_detail_id = p_trx_detail_id;
7477:
7478: l_sales NUMBER := 0;

Line 7606: pn_var_trx_details_all dtls

7602: hdr.line_item_group_id,
7603: hdr.period_id,
7604: hdr.var_rent_id
7605: FROM pn_var_trx_headers_all hdr,
7606: pn_var_trx_details_all dtls
7607: WHERE hdr.trx_header_id = dtls.trx_header_id
7608: AND dtls.trx_detail_id = p_trx_detail_id;
7609:
7610: l_first_period VARCHAR2(1) := 'N';

Line 7715: pn_var_trx_details_all dtls

7711: hdr.trx_header_id,
7712: hdr.calc_prd_start_date,
7713: hdr.line_item_id
7714: FROM pn_var_trx_headers_all hdr,
7715: pn_var_trx_details_all dtls
7716: WHERE hdr.trx_header_id = dtls.trx_header_id
7717: AND dtls.trx_detail_id = p_trx_detail_id;
7718:
7719: -- Get the details of

Line 7837: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr

7833: dtls.bkpt_rate,
7834: hdr.var_rent_id,
7835: hdr.period_id,
7836: hdr.line_item_group_id
7837: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr
7838: WHERE dtls.trx_detail_id = p_trx_detail_id
7839: AND hdr.trx_header_id = dtls.trx_header_id;
7840:
7841: CURSOR blended_prd_csr (p_period_id IN NUMBER, p_bkpt_rate IN NUMBER) IS

Line 7843: FROM pn_var_trx_details_all dtls,

7839: AND hdr.trx_header_id = dtls.trx_header_id;
7840:
7841: CURSOR blended_prd_csr (p_period_id IN NUMBER, p_bkpt_rate IN NUMBER) IS
7842: SELECT sum(dtls.prorated_grp_vol_start) bkpt_start
7843: FROM pn_var_trx_details_all dtls,
7844: pn_var_trx_headers_all hdr
7845: WHERE hdr.trx_header_id = dtls.trx_header_id
7846: AND hdr.period_id = p_period_id
7847: AND dtls.bkpt_rate = p_bkpt_rate;

Line 7983: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr

7979: dtls.bkpt_rate,
7980: hdr.var_rent_id,
7981: hdr.period_id,
7982: hdr.line_item_group_id
7983: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr
7984: WHERE dtls.trx_detail_id = p_trx_detail_id
7985: AND hdr.trx_header_id = dtls.trx_header_id;
7986:
7987: CURSOR blended_prd_csr (p_period_id IN NUMBER, p_bkpt_rate IN NUMBER) IS

Line 7990: FROM pn_var_trx_details_all dtls,

7986:
7987: CURSOR blended_prd_csr (p_period_id IN NUMBER, p_bkpt_rate IN NUMBER) IS
7988: SELECT sum(prorated_grp_vol_start) bkpt_start,
7989: sum(prorated_grp_vol_end) bkpt_end
7990: FROM pn_var_trx_details_all dtls,
7991: pn_var_trx_headers_all hdr
7992: WHERE hdr.trx_header_id = dtls.trx_header_id
7993: AND hdr.period_id = p_period_id
7994: AND dtls.bkpt_rate = p_bkpt_rate;

Line 8126: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr,

8122: bkpts.group_bkpt_vol_start,
8123: hdr.var_rent_id,
8124: hdr.period_id,
8125: hdr.line_item_group_id
8126: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr,
8127: pn_var_bkpts_det_all bkpts
8128: WHERE dtls.trx_detail_id = p_trx_detail_id
8129: AND hdr.trx_header_id = dtls.trx_header_id
8130: AND bkpts.bkpt_detail_id = dtls.bkpt_detail_id;

Line 8237: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr,

8233: bkpts.group_bkpt_vol_end,
8234: hdr.var_rent_id,
8235: hdr.period_id,
8236: hdr.line_item_group_id
8237: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr,
8238: pn_var_bkpts_det_all bkpts
8239: WHERE dtls.trx_detail_id = p_trx_detail_id
8240: AND hdr.trx_header_id = dtls.trx_header_id
8241: AND bkpts.bkpt_detail_id = dtls.bkpt_detail_id;

Line 8339: pn_var_trx_details_all dtls

8335: hdr.first_yr_rent,
8336: hdr.period_id,
8337: hdr.var_rent_id
8338: FROM pn_var_trx_headers_all hdr,
8339: pn_var_trx_details_all dtls
8340: WHERE hdr.trx_header_id = dtls.trx_header_id
8341: AND dtls.trx_detail_id = p_trx_detail_id;
8342:
8343: -- Get the details of

Line 8439: pn_var_trx_details_all dtls

8435: hdr.first_yr_rent,
8436: hdr.period_id,
8437: hdr.var_rent_id
8438: FROM pn_var_trx_headers_all hdr,
8439: pn_var_trx_details_all dtls
8440: WHERE hdr.trx_header_id = dtls.trx_header_id
8441: AND dtls.trx_detail_id = p_trx_detail_id;
8442:
8443: -- Get the details of

Line 8690: pn_var_trx_details_all dtls

8686: ,dtls.ytd_group_vol_end AS trueup_bkpt_vol_end
8687: ,hdr.ytd_sales AS trueup_volume
8688: ,hdr.ytd_deductions AS deductions
8689: FROM pn_var_trx_headers_all hdr,
8690: pn_var_trx_details_all dtls
8691: WHERE dtls.trx_detail_id = p_trx_detail_id
8692: AND dtls.bkpt_rate = p_rate
8693: AND dtls.trx_header_id = hdr.trx_header_id;
8694:

Line 10733: FROM pn_var_trx_details_all dtls,

10729:
10730: CURSOR get_blended_bkpt_csr(p_var_rent_id IN NUMBER) IS
10731: SELECT sum(pr_grp_blended_vol_start) bkpt_start,
10732: sum(pr_grp_blended_vol_end) bkpt_end
10733: FROM pn_var_trx_details_all dtls,
10734: pn_var_trx_headers_all hdr
10735: WHERE var_rent_id = p_var_rent_id
10736: AND hdr.trx_header_id = dtls.trx_header_id
10737: AND dtls.bkpt_rate = p_bkpt_rate