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.PO_WF_REQ_NOTIFICATION dependencies on PO_REQUISITION_LINES

Line 48: req_line_id po_requisition_lines.requisition_line_id%TYPE,

44: username in varchar2);
45:
46: TYPE line_record IS RECORD (
47:
48: req_line_id po_requisition_lines.requisition_line_id%TYPE,
49: line_num po_requisition_lines.line_num%TYPE,
50: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
51: item_revision po_requisition_lines.item_revision%TYPE,
52: item_desc po_requisition_lines.item_description%TYPE,

Line 49: line_num po_requisition_lines.line_num%TYPE,

45:
46: TYPE line_record IS RECORD (
47:
48: req_line_id po_requisition_lines.requisition_line_id%TYPE,
49: line_num po_requisition_lines.line_num%TYPE,
50: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
51: item_revision po_requisition_lines.item_revision%TYPE,
52: item_desc po_requisition_lines.item_description%TYPE,
53: -- uom po_requisition_lines.unit_meas_lookup_code%TYPE, -- Bug 2401933.remove

Line 51: item_revision po_requisition_lines.item_revision%TYPE,

47:
48: req_line_id po_requisition_lines.requisition_line_id%TYPE,
49: line_num po_requisition_lines.line_num%TYPE,
50: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
51: item_revision po_requisition_lines.item_revision%TYPE,
52: item_desc po_requisition_lines.item_description%TYPE,
53: -- uom po_requisition_lines.unit_meas_lookup_code%TYPE, -- Bug 2401933.remove
54: uom mtl_units_of_measure.unit_of_measure_tl%TYPE, -- Bug 2401933.add
55: quantity po_requisition_lines.quantity%TYPE,

Line 52: item_desc po_requisition_lines.item_description%TYPE,

48: req_line_id po_requisition_lines.requisition_line_id%TYPE,
49: line_num po_requisition_lines.line_num%TYPE,
50: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
51: item_revision po_requisition_lines.item_revision%TYPE,
52: item_desc po_requisition_lines.item_description%TYPE,
53: -- uom po_requisition_lines.unit_meas_lookup_code%TYPE, -- Bug 2401933.remove
54: uom mtl_units_of_measure.unit_of_measure_tl%TYPE, -- Bug 2401933.add
55: quantity po_requisition_lines.quantity%TYPE,
56: unit_price po_requisition_lines.unit_price%TYPE,

Line 53: -- uom po_requisition_lines.unit_meas_lookup_code%TYPE, -- Bug 2401933.remove

49: line_num po_requisition_lines.line_num%TYPE,
50: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
51: item_revision po_requisition_lines.item_revision%TYPE,
52: item_desc po_requisition_lines.item_description%TYPE,
53: -- uom po_requisition_lines.unit_meas_lookup_code%TYPE, -- Bug 2401933.remove
54: uom mtl_units_of_measure.unit_of_measure_tl%TYPE, -- Bug 2401933.add
55: quantity po_requisition_lines.quantity%TYPE,
56: unit_price po_requisition_lines.unit_price%TYPE,
57: line_amount NUMBER,

Line 55: quantity po_requisition_lines.quantity%TYPE,

51: item_revision po_requisition_lines.item_revision%TYPE,
52: item_desc po_requisition_lines.item_description%TYPE,
53: -- uom po_requisition_lines.unit_meas_lookup_code%TYPE, -- Bug 2401933.remove
54: uom mtl_units_of_measure.unit_of_measure_tl%TYPE, -- Bug 2401933.add
55: quantity po_requisition_lines.quantity%TYPE,
56: unit_price po_requisition_lines.unit_price%TYPE,
57: line_amount NUMBER,
58: need_by_date po_requisition_lines.need_by_date%TYPE,
59: location hr_locations.location_code%TYPE,

Line 56: unit_price po_requisition_lines.unit_price%TYPE,

52: item_desc po_requisition_lines.item_description%TYPE,
53: -- uom po_requisition_lines.unit_meas_lookup_code%TYPE, -- Bug 2401933.remove
54: uom mtl_units_of_measure.unit_of_measure_tl%TYPE, -- Bug 2401933.add
55: quantity po_requisition_lines.quantity%TYPE,
56: unit_price po_requisition_lines.unit_price%TYPE,
57: line_amount NUMBER,
58: need_by_date po_requisition_lines.need_by_date%TYPE,
59: location hr_locations.location_code%TYPE,
60: requestor per_people_f.full_name%TYPE,

Line 58: need_by_date po_requisition_lines.need_by_date%TYPE,

54: uom mtl_units_of_measure.unit_of_measure_tl%TYPE, -- Bug 2401933.add
55: quantity po_requisition_lines.quantity%TYPE,
56: unit_price po_requisition_lines.unit_price%TYPE,
57: line_amount NUMBER,
58: need_by_date po_requisition_lines.need_by_date%TYPE,
59: location hr_locations.location_code%TYPE,
60: requestor per_people_f.full_name%TYPE,
61: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
62: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,

Line 61: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,

57: line_amount NUMBER,
58: need_by_date po_requisition_lines.need_by_date%TYPE,
59: location hr_locations.location_code%TYPE,
60: requestor per_people_f.full_name%TYPE,
61: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
62: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,
63: txn_curr_code po_requisition_lines.currency_code%TYPE,
64: curr_unit_price po_requisition_lines.currency_unit_price%TYPE);
65:

Line 62: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,

58: need_by_date po_requisition_lines.need_by_date%TYPE,
59: location hr_locations.location_code%TYPE,
60: requestor per_people_f.full_name%TYPE,
61: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
62: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,
63: txn_curr_code po_requisition_lines.currency_code%TYPE,
64: curr_unit_price po_requisition_lines.currency_unit_price%TYPE);
65:
66: TYPE history_record IS RECORD (

Line 63: txn_curr_code po_requisition_lines.currency_code%TYPE,

59: location hr_locations.location_code%TYPE,
60: requestor per_people_f.full_name%TYPE,
61: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
62: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,
63: txn_curr_code po_requisition_lines.currency_code%TYPE,
64: curr_unit_price po_requisition_lines.currency_unit_price%TYPE);
65:
66: TYPE history_record IS RECORD (
67:

Line 64: curr_unit_price po_requisition_lines.currency_unit_price%TYPE);

60: requestor per_people_f.full_name%TYPE,
61: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
62: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,
63: txn_curr_code po_requisition_lines.currency_code%TYPE,
64: curr_unit_price po_requisition_lines.currency_unit_price%TYPE);
65:
66: TYPE history_record IS RECORD (
67:
68: seq_num po_action_history_v.sequence_num%TYPE,

Line 158: FROM po_requisition_lines_all

154: l_tax_amount number;
155: l_total_amount number;
156: cursor req_total_csr(p_doc_id number) is
157: SELECT nvl(SUM(quantity * unit_price), 0)
158: FROM po_requisition_lines_all
159: WHERE requisition_header_id = p_doc_id
160: AND NVL(cancel_flag,'N') = 'N'
161: AND NVL(modified_by_agent_flag, 'N') = 'N';
162: cursor req_tax_csr(p_doc_id number) is

Line 164: FROM po_requisition_lines_all rl,

160: AND NVL(cancel_flag,'N') = 'N'
161: AND NVL(modified_by_agent_flag, 'N') = 'N';
162: cursor req_tax_csr(p_doc_id number) is
163: SELECT nvl(sum(nonrecoverable_tax), 0)
164: FROM po_requisition_lines_all rl,
165: po_req_distributions_all rd
166: WHERE rl.requisition_header_id = p_doc_id
167: AND rd.requisition_line_id = rl.requisition_line_id
168: AND NVL(rl.cancel_flag,'N') = 'N'

Line 336: FROM po_requisition_lines rl,

332: end if;
333:
334: SELECT nvl(sum(nonrecoverable_tax), 0)
335: INTO l_tax_amt
336: FROM po_requisition_lines rl,
337: po_req_distributions_all rd --
338: WHERE rl.requisition_header_id = l_document_id
339: AND rd.requisition_line_id = rl.requisition_line_id;
340:

Line 601: FROM po_requisition_lines rl,

597: end if;
598:
599: SELECT nvl(sum(nonrecoverable_tax), 0)
600: INTO l_tax_amt
601: FROM po_requisition_lines rl,
602: po_req_distributions_all rd --
603: WHERE rl.requisition_header_id = l_document_id
604: AND rd.requisition_line_id = rl.requisition_line_id;
605:

Line 843: FROM po_requisition_lines rl,

839: end if;
840:
841: SELECT nvl(sum(nonrecoverable_tax), 0)
842: INTO l_tax_amt
843: FROM po_requisition_lines rl,
844: po_req_distributions_all rd --
845: WHERE rl.requisition_header_id = l_document_id
846: AND rd.requisition_line_id = rl.requisition_line_id;
847:

Line 1069: FROM po_requisition_lines rl,

1065: end if;
1066:
1067: SELECT nvl(sum(nonrecoverable_tax), 0)
1068: INTO l_tax_amt
1069: FROM po_requisition_lines rl,
1070: po_req_distributions_all rd --
1071: WHERE rl.requisition_header_id = l_document_id
1072: AND rd.requisition_line_id = rl.requisition_line_id;
1073:

Line 1171: l_document_id po_requisition_lines.requisition_header_id%TYPE;

1167:
1168: l_item_type wf_items.item_type%TYPE;
1169: l_item_key wf_items.item_key%TYPE;
1170:
1171: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1172: l_org_id po_requisition_lines.org_id%TYPE;
1173:
1174: l_line line_record;
1175:

Line 1172: l_org_id po_requisition_lines.org_id%TYPE;

1168: l_item_type wf_items.item_type%TYPE;
1169: l_item_key wf_items.item_key%TYPE;
1170:
1171: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1172: l_org_id po_requisition_lines.org_id%TYPE;
1173:
1174: l_line line_record;
1175:
1176: l_document VARCHAR2(32000) := '';

Line 1224: FROM po_requisition_lines rql,

1220: rql.suggested_vendor_name,
1221: rql.suggested_vendor_location,
1222: rql.currency_code,
1223: rql.currency_unit_price
1224: FROM po_requisition_lines rql,
1225: mtl_system_items_kfv msi,
1226: hr_locations_all hrt,
1227: mtl_units_of_measure muom, -- bug 2401933.add
1228: per_all_people_f per -- Bug 3404451

Line 1400: l_document_id po_requisition_lines.requisition_header_id%TYPE;

1396:
1397: l_item_type wf_items.item_type%TYPE;
1398: l_item_key wf_items.item_key%TYPE;
1399:
1400: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1401: l_org_id po_requisition_lines.org_id%TYPE;
1402:
1403: l_line line_record;
1404: l_disp_item VARCHAR2(1);

Line 1401: l_org_id po_requisition_lines.org_id%TYPE;

1397: l_item_type wf_items.item_type%TYPE;
1398: l_item_key wf_items.item_key%TYPE;
1399:
1400: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1401: l_org_id po_requisition_lines.org_id%TYPE;
1402:
1403: l_line line_record;
1404: l_disp_item VARCHAR2(1);
1405:

Line 1477: FROM po_requisition_lines rql,

1473: decode(rql.source_type_code,'VENDOR', rql.suggested_vendor_name, org.organization_code ||' - '|| org.organization_name),
1474: decode(rql.source_type_code, 'VENDOR',rql.suggested_vendor_location,''),
1475: rql.currency_code,
1476: rql.currency_unit_price
1477: FROM po_requisition_lines rql,
1478: mtl_system_items_kfv msi,
1479: hr_locations_all hrt,
1480: per_all_people_f per, -- Bug 3404451
1481: mtl_units_of_measure muom, -- bug 2401933.add

Line 1628: from po_requisition_lines

1624: */
1625:
1626: select count(1)
1627: into l_num_lines
1628: from po_requisition_lines
1629: where requisition_header_id = l_document_id
1630: AND NVL(cancel_flag,'N') = 'N'
1631: AND NVL(modified_by_agent_flag, 'N') = 'N';
1632:

Line 1887: l_document_id po_requisition_lines.requisition_header_id%TYPE;

1883:
1884: l_item_type wf_items.item_type%TYPE;
1885: l_item_key wf_items.item_key%TYPE;
1886:
1887: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1888: l_object_type po_action_history.object_type_code%TYPE;
1889: l_org_id po_requisition_lines.org_id%TYPE;
1890:
1891: l_document VARCHAR2(32000) := '';

Line 1889: l_org_id po_requisition_lines.org_id%TYPE;

1885: l_item_key wf_items.item_key%TYPE;
1886:
1887: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1888: l_object_type po_action_history.object_type_code%TYPE;
1889: l_org_id po_requisition_lines.org_id%TYPE;
1890:
1891: l_document VARCHAR2(32000) := '';
1892: l_document_hist VARCHAR2(32000) := '';
1893: l_document_pend VARCHAR2(32000) := '';

Line 2139: l_document_id po_requisition_lines.requisition_header_id%TYPE;

2135: p_item_key in varchar2,
2136: max_seqno in number,
2137: p_document out NOCOPY varchar2) IS
2138:
2139: l_document_id po_requisition_lines.requisition_header_id%TYPE;
2140: l_object_type po_action_history.object_type_code%TYPE;
2141: l_org_id po_requisition_lines.org_id%TYPE;
2142:
2143: l_document VARCHAR2(32000) := '';

Line 2141: l_org_id po_requisition_lines.org_id%TYPE;

2137: p_document out NOCOPY varchar2) IS
2138:
2139: l_document_id po_requisition_lines.requisition_header_id%TYPE;
2140: l_object_type po_action_history.object_type_code%TYPE;
2141: l_org_id po_requisition_lines.org_id%TYPE;
2142:
2143: l_document VARCHAR2(32000) := '';
2144: l_sub_document VARCHAR2(32000) := '';
2145: l_one_row VARCHAR2(32000) := '';

Line 2324: l_document_id po_requisition_lines.requisition_header_id%TYPE;

2320:
2321: l_item_type wf_items.item_type%TYPE;
2322: l_item_key wf_items.item_key%TYPE;
2323:
2324: l_document_id po_requisition_lines.requisition_header_id%TYPE;
2325: l_object_type po_action_history.object_type_code%TYPE;
2326: l_org_id po_requisition_lines.org_id%TYPE;
2327:
2328: l_document VARCHAR2(32000) := '';

Line 2326: l_org_id po_requisition_lines.org_id%TYPE;

2322: l_item_key wf_items.item_key%TYPE;
2323:
2324: l_document_id po_requisition_lines.requisition_header_id%TYPE;
2325: l_object_type po_action_history.object_type_code%TYPE;
2326: l_org_id po_requisition_lines.org_id%TYPE;
2327:
2328: l_document VARCHAR2(32000) := '';
2329:
2330: l_history history_record;

Line 3617: l_currency_code po_requisition_lines.currency_code%TYPE;

3613:
3614: function is_foreign_currency_displayed (p_document_id in number, p_func_currency_code in varchar2) return boolean IS
3615:
3616: l_max_lines number := 0;
3617: l_currency_code po_requisition_lines.currency_code%TYPE;
3618:
3619: begin
3620: l_max_lines := to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));
3621:

Line 3627: FROM po_requisition_lines

3623: -- SQL Why: need to check if need to display foregin currency column
3624: select currency_code into l_currency_code from
3625: (select currency_code from
3626: (SELECT currency_code
3627: FROM po_requisition_lines
3628: WHERE requisition_header_id = p_document_id
3629: AND NVL(cancel_flag,'N') = 'N'
3630: AND NVL(modified_by_agent_flag, 'N') = 'N'
3631: order by line_num) a