DBA Data[Home] [Help]

APPS.PO_CHG_REQUEST_PVT dependencies on PO_LINES_ALL

Line 1675: FROM po_lines_all

1671: if (p_po_change_requests(i).po_release_id is not null) then
1672:
1673: SELECT decode(price_break_lookup_code, 'CUMULATIVE', 'Y', 'N')
1674: INTO l_price_break_type
1675: FROM po_lines_all
1676: WHERE po_line_id = p_po_change_requests(i).document_line_id;
1677:
1678: IF (l_price_break_type = 'Y') THEN
1679: l_cumulative_flag := TRUE;

Line 2030: x_price_change po_lines_all.allow_price_override_flag%type;

2026: v_qty_billed number;
2027: v_accr_rcpt_cnt number;
2028: v_qty_rcvd number;
2029: x_display_stat varchar2(1) :='Y';
2030: x_price_change po_lines_all.allow_price_override_flag%type;
2031: x_order_type po_line_types.order_type_lookup_code%type;
2032: l_return_status varchar2(3);
2033: l_retro_active_price_change varchar2(3);
2034: l_doc_type varchar2(25);

Line 2046: from po_lines_all

2042: begin
2043:
2044: select nvl(allow_price_override_flag,'N')
2045: into x_price_change
2046: from po_lines_all
2047: where po_line_id =
2048: (select from_line_id
2049: from po_lines_all
2050: where po_line_id=p_po_line_id);

Line 2049: from po_lines_all

2045: into x_price_change
2046: from po_lines_all
2047: where po_line_id =
2048: (select from_line_id
2049: from po_lines_all
2050: where po_line_id=p_po_line_id);
2051: exception
2052: when no_data_found then
2053: x_price_change :='Y';

Line 2060: from po_headers_all poh, po_lines_all pol

2056:
2057: --See if the PO is of type BLANKET; if so, the price can be updatable at any time.
2058: select poh.type_lookup_code
2059: into l_doc_type
2060: from po_headers_all poh, po_lines_all pol
2061: where poh.po_header_id = pol.po_header_id
2062: and po_line_id = p_po_line_id;
2063:
2064: if (l_doc_type = 'STANDARD') then

Line 2071: from po_lines_all pol,po_line_types polt

2067: --PO API does not cover this.
2068: begin
2069: select polt.ORDER_TYPE_LOOKUP_CODE,PO_HEADER_ID
2070: into x_order_type,x_po_header_id
2071: from po_lines_all pol,po_line_types polt
2072: where pol.po_line_id = p_po_line_id and
2073: pol.line_type_id = polt.line_type_id;
2074: exception
2075: when no_data_found then

Line 2224: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL

2220: BEGIN
2221: if (p_po_release_id is not null) then
2222: SELECT count(*)
2223: INTO x_ship_count
2224: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL
2225: WHERE POLL.po_release_id = p_po_release_id
2226: AND POLL.po_line_id = POL.po_line_id
2227: AND nvl(POLL.cancel_flag, 'N') = 'N'
2228: AND nvl(POLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'

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

2233: AND POL.order_type_lookup_code NOT IN ('RATE', 'FIXED PRICE');
2234: else
2235: SELECT count(*)
2236: INTO x_ship_count
2237: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL,PO_HEADERS_ALL POH
2238: WHERE
2239: POH.PO_HEADER_ID = p_po_header_id
2240: AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
2241: AND POH.TYPE_LOOKUP_CODE ='STANDARD'

Line 3679: FROM PO_LINE_LOCATIONS_ALL POLL, PO_LINES_ALL POL

3675: l_quan_billed := -1;
3676: begin
3677: SELECT nvl(POLL.quantity, 0), nvl(POLL.quantity_billed, 0), nvl(POLL.quantity_received, 0)
3678: into l_quan_ordered, l_quan_billed, l_quan_recd
3679: FROM PO_LINE_LOCATIONS_ALL POLL, PO_LINES_ALL POL
3680: WHERE POLL.line_location_id = l_po_change_requests(j).document_line_location_id
3681: AND POLL.po_line_id = POL.po_line_id
3682: AND nvl(POLL.cancel_flag, 'N') = 'N'
3683: AND nvl(POLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 3710: FROM PO_LINE_LOCATIONS_ALL POLL, PO_LINES_ALL POL

3706: l_quan_billed := -1;
3707: begin
3708: SELECT nvl(POLL.quantity, 0), nvl(POLL.quantity_billed, 0), nvl(POLL.quantity_received, 0)
3709: into l_quan_ordered, l_quan_billed, l_quan_recd
3710: FROM PO_LINE_LOCATIONS_ALL POLL, PO_LINES_ALL POL
3711: WHERE POLL.line_location_id = l_po_change_requests(j).document_line_location_id
3712: AND POLL.po_line_id = POL.po_line_id
3713: AND nvl(POLL.cancel_flag, 'N') = 'N'
3714: AND nvl(POLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'