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_REQCHANGEREQUESTNOTIF_PVT dependencies on PO_REQUISITION_LINES

Line 209: req_line_id po_requisition_lines.requisition_line_id%TYPE,

205:
206:
207: TYPE line_record IS RECORD (
208:
209: req_line_id po_requisition_lines.requisition_line_id%TYPE,
210: line_num po_requisition_lines.line_num%TYPE,
211: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
212: item_revision po_requisition_lines.item_revision%TYPE,
213: item_desc po_requisition_lines.item_description%TYPE,

Line 210: line_num po_requisition_lines.line_num%TYPE,

206:
207: TYPE line_record IS RECORD (
208:
209: req_line_id po_requisition_lines.requisition_line_id%TYPE,
210: line_num po_requisition_lines.line_num%TYPE,
211: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
212: item_revision po_requisition_lines.item_revision%TYPE,
213: item_desc po_requisition_lines.item_description%TYPE,
214: uom mtl_units_of_measure.unit_of_measure_tl%TYPE,

Line 212: item_revision po_requisition_lines.item_revision%TYPE,

208:
209: req_line_id po_requisition_lines.requisition_line_id%TYPE,
210: line_num po_requisition_lines.line_num%TYPE,
211: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
212: item_revision po_requisition_lines.item_revision%TYPE,
213: item_desc po_requisition_lines.item_description%TYPE,
214: uom mtl_units_of_measure.unit_of_measure_tl%TYPE,
215: quantity po_requisition_lines.quantity%TYPE,
216: unit_price po_requisition_lines.unit_price%TYPE,

Line 213: item_desc po_requisition_lines.item_description%TYPE,

209: req_line_id po_requisition_lines.requisition_line_id%TYPE,
210: line_num po_requisition_lines.line_num%TYPE,
211: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
212: item_revision po_requisition_lines.item_revision%TYPE,
213: item_desc po_requisition_lines.item_description%TYPE,
214: uom mtl_units_of_measure.unit_of_measure_tl%TYPE,
215: quantity po_requisition_lines.quantity%TYPE,
216: unit_price po_requisition_lines.unit_price%TYPE,
217: line_amount NUMBER,

Line 215: quantity po_requisition_lines.quantity%TYPE,

211: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
212: item_revision po_requisition_lines.item_revision%TYPE,
213: item_desc po_requisition_lines.item_description%TYPE,
214: uom mtl_units_of_measure.unit_of_measure_tl%TYPE,
215: quantity po_requisition_lines.quantity%TYPE,
216: unit_price po_requisition_lines.unit_price%TYPE,
217: line_amount NUMBER,
218: need_by_date po_requisition_lines.need_by_date%TYPE,
219: location hr_locations.location_code%TYPE,

Line 216: unit_price po_requisition_lines.unit_price%TYPE,

212: item_revision po_requisition_lines.item_revision%TYPE,
213: item_desc po_requisition_lines.item_description%TYPE,
214: uom mtl_units_of_measure.unit_of_measure_tl%TYPE,
215: quantity po_requisition_lines.quantity%TYPE,
216: unit_price po_requisition_lines.unit_price%TYPE,
217: line_amount NUMBER,
218: need_by_date po_requisition_lines.need_by_date%TYPE,
219: location hr_locations.location_code%TYPE,
220: requestor per_people_f.full_name%TYPE,

Line 218: need_by_date po_requisition_lines.need_by_date%TYPE,

214: uom mtl_units_of_measure.unit_of_measure_tl%TYPE,
215: quantity po_requisition_lines.quantity%TYPE,
216: unit_price po_requisition_lines.unit_price%TYPE,
217: line_amount NUMBER,
218: need_by_date po_requisition_lines.need_by_date%TYPE,
219: location hr_locations.location_code%TYPE,
220: requestor per_people_f.full_name%TYPE,
221: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
222: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,

Line 221: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,

217: line_amount NUMBER,
218: need_by_date po_requisition_lines.need_by_date%TYPE,
219: location hr_locations.location_code%TYPE,
220: requestor per_people_f.full_name%TYPE,
221: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
222: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,
223: txn_curr_code po_requisition_lines.currency_code%TYPE,
224: curr_unit_price po_requisition_lines.currency_unit_price%TYPE,
225: order_type po_lookup_codes.displayed_field%TYPE,

Line 222: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,

218: need_by_date po_requisition_lines.need_by_date%TYPE,
219: location hr_locations.location_code%TYPE,
220: requestor per_people_f.full_name%TYPE,
221: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
222: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,
223: txn_curr_code po_requisition_lines.currency_code%TYPE,
224: curr_unit_price po_requisition_lines.currency_unit_price%TYPE,
225: order_type po_lookup_codes.displayed_field%TYPE,
226: source_type_code po_requisition_lines.source_type_code%TYPE,

Line 223: txn_curr_code po_requisition_lines.currency_code%TYPE,

219: location hr_locations.location_code%TYPE,
220: requestor per_people_f.full_name%TYPE,
221: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
222: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,
223: txn_curr_code po_requisition_lines.currency_code%TYPE,
224: curr_unit_price po_requisition_lines.currency_unit_price%TYPE,
225: order_type po_lookup_codes.displayed_field%TYPE,
226: source_type_code po_requisition_lines.source_type_code%TYPE,
227: line_location_id po_requisition_lines.line_location_id%TYPE,

Line 224: curr_unit_price po_requisition_lines.currency_unit_price%TYPE,

220: requestor per_people_f.full_name%TYPE,
221: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
222: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,
223: txn_curr_code po_requisition_lines.currency_code%TYPE,
224: curr_unit_price po_requisition_lines.currency_unit_price%TYPE,
225: order_type po_lookup_codes.displayed_field%TYPE,
226: source_type_code po_requisition_lines.source_type_code%TYPE,
227: line_location_id po_requisition_lines.line_location_id%TYPE,
228: cancel_flag po_requisition_lines.cancel_flag%TYPE

Line 226: source_type_code po_requisition_lines.source_type_code%TYPE,

222: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,
223: txn_curr_code po_requisition_lines.currency_code%TYPE,
224: curr_unit_price po_requisition_lines.currency_unit_price%TYPE,
225: order_type po_lookup_codes.displayed_field%TYPE,
226: source_type_code po_requisition_lines.source_type_code%TYPE,
227: line_location_id po_requisition_lines.line_location_id%TYPE,
228: cancel_flag po_requisition_lines.cancel_flag%TYPE
229: );
230:

Line 227: line_location_id po_requisition_lines.line_location_id%TYPE,

223: txn_curr_code po_requisition_lines.currency_code%TYPE,
224: curr_unit_price po_requisition_lines.currency_unit_price%TYPE,
225: order_type po_lookup_codes.displayed_field%TYPE,
226: source_type_code po_requisition_lines.source_type_code%TYPE,
227: line_location_id po_requisition_lines.line_location_id%TYPE,
228: cancel_flag po_requisition_lines.cancel_flag%TYPE
229: );
230:
231: TYPE history_record IS RECORD (

Line 228: cancel_flag po_requisition_lines.cancel_flag%TYPE

224: curr_unit_price po_requisition_lines.currency_unit_price%TYPE,
225: order_type po_lookup_codes.displayed_field%TYPE,
226: source_type_code po_requisition_lines.source_type_code%TYPE,
227: line_location_id po_requisition_lines.line_location_id%TYPE,
228: cancel_flag po_requisition_lines.cancel_flag%TYPE
229: );
230:
231: TYPE history_record IS RECORD (
232:

Line 365: from po_requisition_lines_all prl,

361: select to_char(sum(decode(pcr1.action_type, 'CANCELLATION', 0, nvl(pcr1.new_price, prl.unit_price)*
362: nvl(pcr2.new_quantity,prd.req_line_quantity)*prd.nonrecoverable_tax
363: /(prl.unit_price*prd.req_line_quantity))), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
364: into l_new_tax_amount
365: from po_requisition_lines_all prl,
366: po_req_distributions_all prd,
367: po_change_requests pcr1,
368: po_change_requests pcr2
369: where prl.requisition_line_id=pcr1.document_line_id(+)

Line 384: from po_requisition_lines_all prl,

380: select to_char(sum(decode(pcr1.action_type, 'CANCELLATION', 0, nvl(pcr1.new_price, prl.unit_price)*
381: nvl(pcr2.new_quantity,prd.req_line_quantity))),
382: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
383: into l_new_req_amount
384: from po_requisition_lines_all prl,
385: po_req_distributions_all prd,
386: po_change_requests pcr1,
387: po_change_requests pcr2
388: where prl.requisition_line_id=pcr1.document_line_id(+)

Line 529: FROM po_requisition_lines rl,

525: end if;
526:
527: SELECT to_char(nvl(sum(nonrecoverable_tax), 0), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
528: INTO l_new_tax_amount
529: FROM po_requisition_lines rl,
530: po_req_distributions rd
531: WHERE rl.requisition_header_id = l_document_id
532: AND rd.requisition_line_id = rl.requisition_line_id
533: AND NVL(rl.modified_by_agent_flag, 'N') = 'N'

Line 538: FROM po_requisition_lines

534: and NVL(rl.cancel_flag, 'N')='N';
535:
536: SELECT to_char(nvl(SUM(quantity * unit_price), 0), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
537: into l_new_req_amount
538: FROM po_requisition_lines
539: WHERE requisition_header_id = l_document_id
540: AND NVL(cancel_flag,'N') = 'N'
541: AND NVL(modified_by_agent_flag, 'N') = 'N';
542: */

Line 608: l_document_id po_requisition_lines.requisition_header_id%TYPE;

604:
605: l_item_type wf_items.item_type%TYPE;
606: l_item_key wf_items.item_key%TYPE;
607:
608: l_document_id po_requisition_lines.requisition_header_id%TYPE;
609: l_org_id po_requisition_lines.org_id%TYPE;
610:
611: l_line line_record;
612:

Line 609: l_org_id po_requisition_lines.org_id%TYPE;

605: l_item_type wf_items.item_type%TYPE;
606: l_item_key wf_items.item_key%TYPE;
607:
608: l_document_id po_requisition_lines.requisition_header_id%TYPE;
609: l_org_id po_requisition_lines.org_id%TYPE;
610:
611: l_line line_record;
612:
613: l_num_lines NUMBER := 0;

Line 677: FROM po_requisition_lines rql,

673: PLC.DISPLAYED_FIELD,
674: rql.source_type_code,
675: rql.line_location_id,
676: rql.cancel_flag
677: FROM po_requisition_lines rql,
678: mtl_system_items_kfv msi,
679: hr_locations_all hrt,
680: per_all_people_f per,
681: mtl_units_of_measure muom,

Line 781: from po_requisition_lines

777: l_max_lines := to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));
778:
779: select count(1)
780: into l_num_lines
781: from po_requisition_lines
782: where requisition_header_id = l_document_id;
783:
784: l_document := l_document || '' || NL;
785:
Line 1120: l_document_id po_requisition_lines.requisition_header_id%TYPE;

1116:
1117: l_item_type wf_items.item_type%TYPE;
1118: l_item_key wf_items.item_key%TYPE;
1119:
1120: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1121: l_org_id po_requisition_lines.org_id%TYPE;
1122:
1123: l_line line_record;
1124:

Line 1121: l_org_id po_requisition_lines.org_id%TYPE;

1117: l_item_type wf_items.item_type%TYPE;
1118: l_item_key wf_items.item_key%TYPE;
1119:
1120: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1121: l_org_id po_requisition_lines.org_id%TYPE;
1122:
1123: l_line line_record;
1124:
1125: l_num_lines NUMBER := 0;

Line 1188: FROM po_requisition_lines rql,

1184: PLC.DISPLAYED_FIELD,
1185: rql.source_type_code,
1186: rql.line_location_id,
1187: rql.cancel_flag
1188: FROM po_requisition_lines rql,
1189: mtl_system_items_kfv msi,
1190: hr_locations_all hrt,
1191: per_all_people_f per,
1192: mtl_units_of_measure muom,

Line 1292: from po_requisition_lines

1288: l_max_lines := to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));
1289:
1290: select count(1)
1291: into l_num_lines
1292: from po_requisition_lines
1293: where requisition_header_id = l_document_id;
1294:
1295: l_document := l_document || '

' || NL;
1296:
Line 1631: l_document_id po_requisition_lines.requisition_header_id%TYPE;

1627:
1628: l_item_type wf_items.item_type%TYPE;
1629: l_item_key wf_items.item_key%TYPE;
1630:
1631: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1632: l_object_type po_action_history.object_type_code%TYPE;
1633: l_org_id po_requisition_lines.org_id%TYPE;
1634:
1635: l_document VARCHAR2(32000) := '';

Line 1633: l_org_id po_requisition_lines.org_id%TYPE;

1629: l_item_key wf_items.item_key%TYPE;
1630:
1631: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1632: l_object_type po_action_history.object_type_code%TYPE;
1633: l_org_id po_requisition_lines.org_id%TYPE;
1634:
1635: l_document VARCHAR2(32000) := '';
1636: l_document_hist VARCHAR2(32000) := '';
1637: l_document_pend VARCHAR2(32000) := '';

Line 1819: l_document_id po_requisition_lines.requisition_header_id%TYPE;

1815: p_item_key in varchar2,
1816: max_seqno in number,
1817: p_document out NOCOPY varchar2) IS
1818:
1819: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1820: l_object_type po_action_history.object_type_code%TYPE;
1821: l_org_id po_requisition_lines.org_id%TYPE;
1822:
1823: l_document VARCHAR2(32000) := '';

Line 1821: l_org_id po_requisition_lines.org_id%TYPE;

1817: p_document out NOCOPY varchar2) IS
1818:
1819: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1820: l_object_type po_action_history.object_type_code%TYPE;
1821: l_org_id po_requisition_lines.org_id%TYPE;
1822:
1823: l_document VARCHAR2(32000) := '';
1824: l_sub_document VARCHAR2(32000) := '';
1825: l_one_row VARCHAR2(32000) := '';

Line 2005: from po_requisition_lines_all prl,

2001: nvl(pcr2.new_quantity, prl.quantity))), 0),
2002: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
2003: ||' '|| l_currency_code
2004: into l_new_tax_amount, l_new_req_amount
2005: from po_requisition_lines_all prl,
2006: po_change_requests pcr1,
2007: po_change_requests pcr2,
2008: po_change_requests pcr3
2009: where prl.requisition_line_id=pcr1.document_line_id(+)

Line 2033: FROM po_requisition_lines rl,

2029: SELECT to_char(nvl(sum(nvl(nonrecoverable_tax, 0)), 0),
2030: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
2031: ||' '|| l_currency_code
2032: INTO l_new_tax_amount
2033: FROM po_requisition_lines rl,
2034: po_req_distributions_all rd --
2035: WHERE rl.requisition_header_id = l_document_id
2036: AND rd.requisition_line_id = rl.requisition_line_id
2037: AND NVL(rl.modified_by_agent_flag, 'N') = 'N'

Line 2044: FROM po_requisition_lines

2040: SELECT to_char(nvl(SUM(nvl(quantity * unit_price, 0)), 0),
2041: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
2042: ||' '|| l_currency_code
2043: into l_new_req_amount
2044: FROM po_requisition_lines
2045: WHERE requisition_header_id = l_document_id
2046: AND NVL(cancel_flag,'N') = 'N'
2047: AND NVL(modified_by_agent_flag, 'N') = 'N';
2048:

Line 2153: l_currency po_requisition_lines_all.currency_code%type;

2149: * Returns:
2150: ************************************************************************/
2151: function IsForeignCurrencyDisplayed (l_document_id in number, l_display_txn_curr in varchar2, l_currency_code in varchar2) return boolean IS
2152:
2153: l_currency po_requisition_lines_all.currency_code%type;
2154: begin
2155:
2156: if l_display_txn_curr='Y' then
2157:

Line 2160: FROM po_requisition_lines_all

2156: if l_display_txn_curr='Y' then
2157:
2158: select currency_code
2159: into l_currency
2160: FROM po_requisition_lines_all
2161: WHERE requisition_header_id = l_document_id
2162: AND NVL(cancel_flag,'N') = 'N'
2163: AND NVL(modified_by_agent_flag, 'N') = 'N'
2164: and currency_code <> l_currency_code;

Line 2214: from PO_REQUISITION_LINES PRL,

2210: l_total_count NUMBER;
2211: begin
2212: select to_char(OOH.ORDER_NUMBER), OOL.FLOW_STATUS_CODE, OOL.LINE_ID
2213: INTO l_so_number, l_status_code, l_line_id
2214: from PO_REQUISITION_LINES PRL,
2215: PO_REQUISITION_HEADERS_ALL PRH, --
2216: OE_ORDER_HEADERS_ALL OOH,
2217: OE_ORDER_LINES_ALL OOL,
2218: PO_SYSTEM_PARAMETERS PSP

Line 2940: po_requisition_lines_all prl,

2936: distinct prl.blanket_po_header_id
2937: into
2938: l_blanket_header_id
2939: from
2940: po_requisition_lines_all prl,
2941: po_line_locations_all pll,
2942: po_lines_all pol
2943: where
2944: pol.po_line_id = p_line_id and

Line 3682: po_requisition_lines_all prl,

3678: prl.blanket_po_line_num
3679: into
3680: l_blanket_header_id, l_blanket_line_num
3681: from
3682: po_requisition_lines_all prl,
3683: po_line_locations_all pll,
3684: po_lines_all pol
3685: where
3686: pol.po_line_id = l_line_id and

Line 4084: po_requisition_lines_all prl

4080: prl.blanket_po_header_id
4081: into
4082: l_blanket_header_id
4083: from
4084: po_requisition_lines_all prl
4085: where
4086: prl.line_location_id = p_line_location_id;
4087:
4088: -- bug 5504366

Line 4311: from po_requisition_lines_all prl,

4307:
4308: --using distinct as a line on a blanket can exist on multiple requisitions
4309: select distinct prl.blanket_po_header_id
4310: into l_blanket_po_header_id
4311: from po_requisition_lines_all prl,
4312: po_line_locations_all pll,
4313: po_lines_all pol
4314: where pol.po_line_id = p_line_id
4315: and pol.po_line_id = pll.po_line_id