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_LINES_ALL

Line 29: pn_var_lines_all line

25: CURSOR line_items_lock4bkpt_c(p_vr_id IN NUMBER) IS
26: SELECT
27: line.line_item_id
28: FROM
29: pn_var_lines_all line
30: WHERE
31: line.var_rent_id = p_vr_id AND
32: line.bkpt_update_flag = 'Y'
33: /*FOR UPDATE NOWAIT*/;

Line 40: pn_var_lines_all line

36: CURSOR line_items_lock4salesvol_c(p_vr_id IN NUMBER) IS
37: SELECT
38: line.line_item_id
39: FROM
40: pn_var_lines_all line
41: WHERE
42: line.var_rent_id = p_vr_id AND
43: line.sales_vol_update_flag = 'Y'
44: /*FOR UPDATE NOWAIT*/;

Line 51: pn_var_lines_all line

47: CURSOR line_items_c(p_vr_id IN NUMBER) IS
48: SELECT
49: line.line_item_id
50: FROM
51: pn_var_lines_all line
52: WHERE
53: line.var_rent_id = p_vr_id
54: /*FOR UPDATE NOWAIT*/;
55:

Line 437: pn_var_lines_all line

433: SELECT
434: NVL(line.sales_type_code, 'NULL') AS sales_type_code
435: ,NVL(line.item_category_code, 'NULL') AS item_category_code
436: FROM
437: pn_var_lines_all line
438: WHERE
439: line.var_rent_id = p_vr_id
440: GROUP BY
441: NVL(line.sales_type_code, 'NULL')

Line 469: pn_var_lines_all line

465: line_item_id IN
466: ( SELECT
467: line.line_item_id
468: FROM
469: pn_var_lines_all line
470: WHERE
471: line.var_rent_id = p_var_rent_id AND
472: NVL(line.sales_type_code, 'NULL')
473: = NVL(line_typ_rec.sales_type_code, 'NULL') AND

Line 1533: pn_var_lines_all

1529: SELECT
1530: period_id
1531: ,line_item_id
1532: FROM
1533: pn_var_lines_all
1534: WHERE
1535: var_rent_id = p_vr_id AND
1536: bkpt_update_flag = 'Y'
1537: ORDER BY

Line 1549: pn_var_lines_all

1545: SELECT
1546: period_id
1547: ,line_item_id
1548: FROM
1549: pn_var_lines_all
1550: WHERE
1551: var_rent_id = p_vr_id AND
1552: bkpt_update_flag = 'Y' AND
1553: period_id NOT IN (p_part_prd_id, p_full_prd_id)

Line 1843: pn_var_lines_all

1839: hdr.period_id = p_prd_id AND
1840: hdr.line_item_id IN (SELECT
1841: line_item_id
1842: FROM
1843: pn_var_lines_all
1844: WHERE
1845: var_rent_id = p_vr_id AND
1846: period_id = p_prd_id AND
1847: bkpt_update_flag = 'Y') AND

Line 2154: pn_var_lines_all

2150: MINUS
2151: SELECT
2152: line_item_id
2153: FROM
2154: pn_var_lines_all
2155: WHERE
2156: var_rent_id = p_vr_id AND
2157: period_id = p_prd_id;
2158:

Line 2218: pn_var_lines_all line

2214: SELECT
2215: line.line_item_id
2216: ,line.line_default_id
2217: FROM
2218: pn_var_lines_all line
2219: WHERE
2220: line.period_id = p_prd_id AND
2221: line.bkpt_update_flag = 'Y' AND
2222: EXISTS (SELECT null

Line 2235: pn_var_lines_all line,

2231: SELECT
2232: line.line_item_id
2233: ,line.line_default_id
2234: FROM
2235: pn_var_lines_all line,
2236: pn_var_bkpts_head_all bph
2237: WHERE
2238: line.period_id = p_prd_id AND
2239: line.bkpt_update_flag = 'Y' AND

Line 2863: pn_var_lines_all

2859:
2860: /* reset the bkpt_update_flag */
2861: FORALL line_rec IN 1..l_line_items_lock4bkpt_t.COUNT
2862: UPDATE
2863: pn_var_lines_all
2864: SET
2865: bkpt_update_flag = NULL
2866: ,sales_vol_update_flag = 'Y'
2867: WHERE

Line 3433: pn_var_lines_all

3429: SELECT
3430: period_id
3431: ,line_item_id
3432: FROM
3433: pn_var_lines_all
3434: WHERE
3435: var_rent_id = p_vr_id AND
3436: sales_vol_update_flag = 'Y'
3437: ORDER BY

Line 3449: pn_var_lines_all

3445: SELECT
3446: period_id
3447: ,line_item_id
3448: FROM
3449: pn_var_lines_all
3450: WHERE
3451: var_rent_id = p_vr_id AND
3452: sales_vol_update_flag = 'Y' AND
3453: period_id NOT IN (p_part_prd_id, p_full_prd_id)

Line 3715: pn_var_lines_all

3711: SELECT
3712: period_id
3713: ,line_item_id
3714: FROM
3715: pn_var_lines_all
3716: WHERE
3717: var_rent_id = p_vr_id AND
3718: sales_vol_update_flag = 'Y'
3719: ORDER BY

Line 3875: pn_var_lines_all

3871: END IF;
3872:
3873: FORALL line_rec IN 1..l_line_items_lock4salesvol_t.COUNT
3874: UPDATE
3875: pn_var_lines_all
3876: SET
3877: sales_vol_update_flag = NULL
3878: WHERE
3879: line_item_id = l_line_items_lock4salesvol_t(line_rec);

Line 4200: pn_var_lines_all

4196: SELECT
4197: period_id
4198: ,line_item_id
4199: FROM
4200: pn_var_lines_all
4201: WHERE
4202: var_rent_id = p_vr_id AND
4203: sales_vol_update_flag = 'Y'
4204: ORDER BY

Line 4325: pn_var_lines_all

4321: SELECT
4322: period_id
4323: ,line_item_id
4324: FROM
4325: pn_var_lines_all
4326: WHERE
4327: var_rent_id = p_vr_id AND
4328: sales_vol_update_flag = 'Y'
4329: ORDER BY

Line 4451: pn_var_lines_all

4447:
4448: /*This would be needed in actual sales, but not for forecasted.
4449: FORALL line_rec IN 1..l_line_items_lock4salesvol_t.COUNT
4450: UPDATE
4451: pn_var_lines_all
4452: SET
4453: sales_vol_update_flag = NULL
4454: WHERE
4455: line_item_id = l_line_items_lock4salesvol_t(line_rec);*/

Line 4966: pn_var_lines_all

4962: SELECT
4963: period_id
4964: ,line_item_id
4965: FROM
4966: pn_var_lines_all
4967: WHERE
4968: var_rent_id = p_vr_id
4969: ORDER BY
4970: period_id

Line 4981: pn_var_lines_all

4977: SELECT
4978: period_id
4979: ,line_item_id
4980: FROM
4981: pn_var_lines_all
4982: WHERE
4983: var_rent_id = p_vr_id AND
4984: period_id NOT IN (p_part_prd_id, p_full_prd_id)
4985: ORDER BY

Line 5246: pn_var_lines_all

5242: SELECT
5243: period_id
5244: ,line_item_id
5245: FROM
5246: pn_var_lines_all
5247: WHERE
5248: var_rent_id = p_vr_id
5249: ORDER BY
5250: period_id