APPS.INV_RCV_STD_INSPECT_APIS dependencies on PO_LINES

Line 5303: ,po_lines pol

5299: ,rcv_shipment_headers rsh
5300: ,rcv_shipment_lines rsl
5301: ,rcv_transactions rt
5302: ,po_line_locations pll
5303: ,po_lines pol
5304: ,mtl_system_items msi
5305: ,mtl_customer_items mci
5306: ,oe_order_lines_all oel
5307: WHERE rt.transaction_id = l_rcv_transaction_id

Line 6560: FROM po_asl_suppliers_v pasv, po_lines pl, po_headers ph

6556: begin
6557: -- get ASL -- query provided by jenny zheng from QA team
6558: SELECT pasv.asl_status_id, pasv.asl_status_dsp
6559: into x_asl_status_id, x_asl_status_dsp
6560: FROM po_asl_suppliers_v pasv, po_lines pl, po_headers ph
6561: WHERE pl.item_id = pasv.item_id
6562: AND pl.po_line_id = v_po_line_id -- here use the variable from above
6563: AND pl.po_header_id = ph.po_header_id
6564: AND ph.vendor_id(+) = pasv.vendor_id

Line 6606: x_msg_data := 'NO PO LINES FOUND';

6602:
6603: else if (v_count_po = 0) then
6604: x_po_return_status := -1;
6605: x_msg_count := ' ';
6606: x_msg_data := 'NO PO LINES FOUND';
6607: --dbms_output.put_line('no po lines found');
6608:
6609: else if (v_count_po > 1) then
6610: x_po_return_status := 1;

Line 6607: --dbms_output.put_line('no po lines found');

6603: else if (v_count_po = 0) then
6604: x_po_return_status := -1;
6605: x_msg_count := ' ';
6606: x_msg_data := 'NO PO LINES FOUND';
6607: --dbms_output.put_line('no po lines found');
6608:
6609: else if (v_count_po > 1) then
6610: x_po_return_status := 1;
6611: x_msg_count := ' ';

Line 6612: x_msg_data := 'MULTIPLE PO LINES FOUND';

6608:
6609: else if (v_count_po > 1) then
6610: x_po_return_status := 1;
6611: x_msg_count := ' ';
6612: x_msg_data := 'MULTIPLE PO LINES FOUND';
6613: --dbms_output.put_line('many po lines found');
6614:
6615: end if;
6616: end if;

Line 6613: --dbms_output.put_line('many po lines found');

6609: else if (v_count_po > 1) then
6610: x_po_return_status := 1;
6611: x_msg_count := ' ';
6612: x_msg_data := 'MULTIPLE PO LINES FOUND';
6613: --dbms_output.put_line('many po lines found');
6614:
6615: end if;
6616: end if;
6617: end if;