APPS.PO_CHG_REQUEST_PVT dependencies on PO_LINES_ALL

Line 1548: FROM po_lines_all

1544: if (p_po_change_requests(i).po_release_id is not null) then
1545:
1546: SELECT decode(price_break_lookup_code, 'CUMULATIVE', 'Y', 'N')
1547: INTO l_price_break_type
1548: FROM po_lines_all
1549: WHERE po_line_id = p_po_change_requests(i).document_line_id;
1550:
1551: IF (l_price_break_type = 'Y') THEN
1552: l_cumulative_flag := TRUE;

Line 1883: x_price_change po_lines_all.allow_price_override_flag%type;

1879: v_qty_billed number;
1880: v_accr_rcpt_cnt number;
1881: v_qty_rcvd number;
1882: x_display_stat varchar2(1) :='Y';
1883: x_price_change po_lines_all.allow_price_override_flag%type;
1884: x_order_type po_line_types.order_type_lookup_code%type;
1885: l_return_status varchar2(3);
1886: l_retro_active_price_change varchar2(3);
1887: l_doc_type varchar2(25);

Line 1899: from po_lines_all

1895: begin
1896:
1897: select nvl(allow_price_override_flag,'N')
1898: into x_price_change
1899: from po_lines_all
1900: where po_line_id =
1901: (select from_line_id
1902: from po_lines_all
1903: where po_line_id=p_po_line_id);

Line 1902: from po_lines_all

1898: into x_price_change
1899: from po_lines_all
1900: where po_line_id =
1901: (select from_line_id
1902: from po_lines_all
1903: where po_line_id=p_po_line_id);
1904: exception
1905: when no_data_found then
1906: x_price_change :='Y';

Line 1913: from po_headers_all poh, po_lines_all pol

1909:
1910: --See if the PO is of type BLANKET; if so, the price can be updatable at any time.
1911: select poh.type_lookup_code
1912: into l_doc_type
1913: from po_headers_all poh, po_lines_all pol
1914: where poh.po_header_id = pol.po_header_id
1915: and po_line_id = p_po_line_id;
1916:
1917: if (l_doc_type = 'STANDARD') then

Line 1924: from po_lines_all pol,po_line_types polt

1920: --PO API does not cover this.
1921: begin
1922: select polt.ORDER_TYPE_LOOKUP_CODE,PO_HEADER_ID
1923: into x_order_type,x_po_header_id
1924: from po_lines_all pol,po_line_types polt
1925: where pol.po_line_id = p_po_line_id and
1926: pol.line_type_id = polt.line_type_id;
1927: exception
1928: when no_data_found then

Line 2077: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL

2073: BEGIN
2074: if (p_po_release_id is not null) then
2075: SELECT count(*)
2076: INTO x_ship_count
2077: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL
2078: WHERE POLL.po_release_id = p_po_release_id
2079: AND POLL.po_line_id = POL.po_line_id
2080: AND nvl(POLL.cancel_flag, 'N') = 'N'
2081: AND nvl(POLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 2090: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL,PO_HEADERS_ALL POH

2086: AND POL.order_type_lookup_code NOT IN ('RATE', 'FIXED PRICE');
2087: else
2088: SELECT count(*)
2089: INTO x_ship_count
2090: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL,PO_HEADERS_ALL POH
2091: WHERE
2092: POH.PO_HEADER_ID = p_po_header_id
2093: AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
2094: AND POH.TYPE_LOOKUP_CODE ='STANDARD'

Line 3278: FROM PO_LINE_LOCATIONS_ALL POLL, PO_LINES_ALL POL

3274: l_quan_billed := -1;
3275: begin
3276: SELECT nvl(POLL.quantity, 0), nvl(POLL.quantity_billed, 0), nvl(POLL.quantity_received, 0)
3277: into l_quan_ordered, l_quan_billed, l_quan_recd
3278: FROM PO_LINE_LOCATIONS_ALL POLL, PO_LINES_ALL POL
3279: WHERE POLL.line_location_id = l_po_change_requests(j).document_line_location_id
3280: AND POLL.po_line_id = POL.po_line_id
3281: AND nvl(POLL.cancel_flag, 'N') = 'N'
3282: AND nvl(POLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 3309: FROM PO_LINE_LOCATIONS_ALL POLL, PO_LINES_ALL POL

3305: l_quan_billed := -1;
3306: begin
3307: SELECT nvl(POLL.quantity, 0), nvl(POLL.quantity_billed, 0), nvl(POLL.quantity_received, 0)
3308: into l_quan_ordered, l_quan_billed, l_quan_recd
3309: FROM PO_LINE_LOCATIONS_ALL POLL, PO_LINES_ALL POL
3310: WHERE POLL.line_location_id = l_po_change_requests(j).document_line_location_id
3311: AND POLL.po_line_id = POL.po_line_id
3312: AND nvl(POLL.cancel_flag, 'N') = 'N'
3313: AND nvl(POLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'