APPS.QA_PLAN_ELEMENT_API dependencies on RCV_SHIPMENT_HEADERS

Line 2463: FROM RCV_SHIPMENT_HEADERS

2459:
2460: /* -- Bug 4958763. SQL Repository Fix SQL ID: 15008972
2461: CURSOR c IS
2462: SELECT 1
2463: FROM RCV_SHIPMENT_HEADERS
2464: WHERE receipt_num = x_receipt_number
2465: AND RECEIPT_SOURCE_CODE = 'VENDOR';
2466: */
2467: --

Line 2473: FROM RCV_SHIPMENT_HEADERS RCVSH,

2469: -- changed the query for validationg receipt number to include RMA receipts
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

Line 3923: FROM RCV_SHIPMENT_HEADERS RCVSH,

3919: WHERE receipt_num like :1
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