APPS.QA_PLAN_ELEMENT_API dependencies on PO_VENDORS

Line 1130: FROM po_vendors

1126: id NUMBER;
1127:
1128: CURSOR c (v_name VARCHAR2) IS
1129: SELECT vendor_id
1130: FROM po_vendors
1131: WHERE vendor_name = v_name
1132: AND nvl(end_date_active, sysdate + 1) > sysdate;
1133:
1134: BEGIN

Line 2474: PO_VENDORS POV,

2470: -- pdube Fri Oct 17 00:14:28 PDT 2008
2471: CURSOR c IS
2472: SELECT 1
2473: FROM RCV_SHIPMENT_HEADERS RCVSH,
2474: PO_VENDORS POV,
2475: RCV_TRANSACTIONS RT
2476: WHERE RCVSH.RECEIPT_SOURCE_CODE in ('VENDOR','CUSTOMER') AND
2477: RCVSH.VENDOR_ID = POV.VENDOR_ID(+) AND
2478: RT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID AND

Line 2811: FROM po_vendors

2807: -- After Single Scan LOV
2808: wild := value;
2809:
2810: sql_string := 'SELECT vendor_name, segment1
2811: FROM po_vendors
2812: WHERE vendor_name like :1
2813: AND nvl(end_date_active, sysdate + 1) > sysdate
2814: ORDER BY vendor_name';
2815:

Line 3924: PO_VENDORS POV,

3920: ORDER BY receipt_num';
3921: */
3922: sql_string := 'SELECT RCVSH.receipt_num, POV.vendor_name
3923: FROM RCV_SHIPMENT_HEADERS RCVSH,
3924: PO_VENDORS POV,
3925: RCV_TRANSACTIONS RT
3926: WHERE RCVSH.RECEIPT_SOURCE_CODE in (''VENDOR'',''CUSTOMER'') AND
3927: RCVSH.VENDOR_ID = POV.VENDOR_ID(+) AND
3928: RT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID AND

Line 5087: FROM po_vendors

5083: x_supplier_name OUT NOCOPY VARCHAR2) IS
5084:
5085: CURSOR c IS
5086: SELECT vendor_name
5087: FROM po_vendors
5088: WHERE vendor_id =
5089: ( SELECT vendor_id
5090: FROM qa_specs
5091: WHERE spec_id = p_spec_id );