APPS.INV_RCV_STD_INSPECT_APIS dependencies on PO_LINES

Line 3403: ,po_lines pol

3399: ,rcv_shipment_headers rsh
3400: ,rcv_shipment_lines rsl
3401: ,rcv_transactions rt
3402: ,po_line_locations pll
3403: ,po_lines pol
3404: ,mtl_system_items msi
3405: ,mtl_customer_items mci
3406: ,oe_order_lines_all oel
3407: WHERE rt.transaction_id = l_rcv_transaction_id

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

4657: begin
4658: -- get ASL -- query provided by jenny zheng from QA team
4659: SELECT pasv.asl_status_id, pasv.asl_status_dsp
4660: into x_asl_status_id, x_asl_status_dsp
4661: FROM po_asl_suppliers_v pasv, po_lines pl, po_headers ph
4662: WHERE pl.item_id = pasv.item_id
4663: AND pl.po_line_id = v_po_line_id -- here use the variable from above
4664: AND pl.po_header_id = ph.po_header_id
4665: AND ph.vendor_id(+) = pasv.vendor_id

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

4703:
4704: else if (v_count_po = 0) then
4705: x_po_return_status := -1;
4706: x_msg_count := ' ';
4707: x_msg_data := 'NO PO LINES FOUND';
4708: --dbms_output.put_line('no po lines found');
4709:
4710: else if (v_count_po > 1) then
4711: x_po_return_status := 1;

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

4704: else if (v_count_po = 0) then
4705: x_po_return_status := -1;
4706: x_msg_count := ' ';
4707: x_msg_data := 'NO PO LINES FOUND';
4708: --dbms_output.put_line('no po lines found');
4709:
4710: else if (v_count_po > 1) then
4711: x_po_return_status := 1;
4712: x_msg_count := ' ';

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

4709:
4710: else if (v_count_po > 1) then
4711: x_po_return_status := 1;
4712: x_msg_count := ' ';
4713: x_msg_data := 'MULTIPLE PO LINES FOUND';
4714: --dbms_output.put_line('many po lines found');
4715:
4716: end if;
4717: end if;

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

4710: else if (v_count_po > 1) then
4711: x_po_return_status := 1;
4712: x_msg_count := ' ';
4713: x_msg_data := 'MULTIPLE PO LINES FOUND';
4714: --dbms_output.put_line('many po lines found');
4715:
4716: end if;
4717: end if;
4718: end if;