APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on PO_REQUISITION_LINES_ALL

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 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 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 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