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 1536: pn_var_lines_all

1532: SELECT
1533: period_id
1534: ,line_item_id
1535: FROM
1536: pn_var_lines_all
1537: WHERE
1538: var_rent_id = p_vr_id AND
1539: bkpt_update_flag = 'Y'
1540: ORDER BY

Line 1552: pn_var_lines_all

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

Line 1930: pn_var_lines_all

1926: hdr.period_id = p_prd_id AND
1927: hdr.line_item_id IN (SELECT
1928: line_item_id
1929: FROM
1930: pn_var_lines_all
1931: WHERE
1932: var_rent_id = p_vr_id AND
1933: period_id = p_prd_id AND
1934: bkpt_update_flag = 'Y') AND

Line 2243: pn_var_lines_all

2239: MINUS
2240: SELECT
2241: line_item_id
2242: FROM
2243: pn_var_lines_all
2244: WHERE
2245: var_rent_id = p_vr_id AND
2246: period_id = p_prd_id;
2247:

Line 2307: pn_var_lines_all line

2303: SELECT
2304: line.line_item_id
2305: ,line.line_default_id
2306: FROM
2307: pn_var_lines_all line
2308: WHERE
2309: line.period_id = p_prd_id AND
2310: line.bkpt_update_flag = 'Y' AND
2311: EXISTS (SELECT null

Line 2324: pn_var_lines_all line,

2320: SELECT
2321: line.line_item_id
2322: ,line.line_default_id
2323: FROM
2324: pn_var_lines_all line,
2325: pn_var_bkpts_head_all bph
2326: WHERE
2327: line.period_id = p_prd_id AND
2328: line.bkpt_update_flag = 'Y' AND

Line 2953: pn_var_lines_all

2949:
2950: /* reset the bkpt_update_flag */
2951: FORALL line_rec IN 1..l_line_items_lock4bkpt_t.COUNT
2952: UPDATE
2953: pn_var_lines_all
2954: SET
2955: bkpt_update_flag = NULL
2956: ,sales_vol_update_flag = 'Y'
2957: WHERE

Line 3523: pn_var_lines_all

3519: SELECT
3520: period_id
3521: ,line_item_id
3522: FROM
3523: pn_var_lines_all
3524: WHERE
3525: var_rent_id = p_vr_id AND
3526: sales_vol_update_flag = 'Y'
3527: ORDER BY

Line 3539: pn_var_lines_all

3535: SELECT
3536: period_id
3537: ,line_item_id
3538: FROM
3539: pn_var_lines_all
3540: WHERE
3541: var_rent_id = p_vr_id AND
3542: sales_vol_update_flag = 'Y' AND
3543: period_id NOT IN (p_part_prd_id, p_full_prd_id)

Line 3805: pn_var_lines_all

3801: SELECT
3802: period_id
3803: ,line_item_id
3804: FROM
3805: pn_var_lines_all
3806: WHERE
3807: var_rent_id = p_vr_id AND
3808: sales_vol_update_flag = 'Y'
3809: ORDER BY

Line 3965: pn_var_lines_all

3961: END IF;
3962:
3963: FORALL line_rec IN 1..l_line_items_lock4salesvol_t.COUNT
3964: UPDATE
3965: pn_var_lines_all
3966: SET
3967: sales_vol_update_flag = NULL
3968: WHERE
3969: line_item_id = l_line_items_lock4salesvol_t(line_rec);

Line 4290: pn_var_lines_all

4286: SELECT
4287: period_id
4288: ,line_item_id
4289: FROM
4290: pn_var_lines_all
4291: WHERE
4292: var_rent_id = p_vr_id AND
4293: sales_vol_update_flag = 'Y'
4294: ORDER BY

Line 4415: pn_var_lines_all

4411: SELECT
4412: period_id
4413: ,line_item_id
4414: FROM
4415: pn_var_lines_all
4416: WHERE
4417: var_rent_id = p_vr_id AND
4418: sales_vol_update_flag = 'Y'
4419: ORDER BY

Line 4541: pn_var_lines_all

4537:
4538: /*This would be needed in actual sales, but not for forecasted.
4539: FORALL line_rec IN 1..l_line_items_lock4salesvol_t.COUNT
4540: UPDATE
4541: pn_var_lines_all
4542: SET
4543: sales_vol_update_flag = NULL
4544: WHERE
4545: line_item_id = l_line_items_lock4salesvol_t(line_rec);*/

Line 5056: pn_var_lines_all

5052: SELECT
5053: period_id
5054: ,line_item_id
5055: FROM
5056: pn_var_lines_all
5057: WHERE
5058: var_rent_id = p_vr_id
5059: ORDER BY
5060: period_id

Line 5071: pn_var_lines_all

5067: SELECT
5068: period_id
5069: ,line_item_id
5070: FROM
5071: pn_var_lines_all
5072: WHERE
5073: var_rent_id = p_vr_id AND
5074: period_id NOT IN (p_part_prd_id, p_full_prd_id)
5075: ORDER BY

Line 5336: pn_var_lines_all

5332: SELECT
5333: period_id
5334: ,line_item_id
5335: FROM
5336: pn_var_lines_all
5337: WHERE
5338: var_rent_id = p_vr_id
5339: ORDER BY
5340: period_id