APPS.QA_PLAN_ELEMENT_API dependencies on RCV_SHIPMENT_HEADERS

Line 2439: FROM RCV_SHIPMENT_HEADERS

2435:
2436: /* -- Bug 4958763. SQL Repository Fix SQL ID: 15008972
2437: CURSOR c IS
2438: SELECT 1
2439: FROM RCV_SHIPMENT_HEADERS
2440: WHERE receipt_num = x_receipt_number
2441: AND RECEIPT_SOURCE_CODE = 'VENDOR';
2442: */
2443: --

Line 2449: FROM RCV_SHIPMENT_HEADERS RCVSH,

2445: -- changed the query for validationg receipt number to include RMA receipts
2446: -- pdube Fri Oct 17 00:14:28 PDT 2008
2447: CURSOR c IS
2448: SELECT 1
2449: FROM RCV_SHIPMENT_HEADERS RCVSH,
2450: PO_VENDORS POV,
2451: RCV_TRANSACTIONS RT
2452: WHERE RCVSH.RECEIPT_SOURCE_CODE in ('VENDOR','CUSTOMER') AND
2453: RCVSH.VENDOR_ID = POV.VENDOR_ID(+) AND

Line 3791: FROM RCV_SHIPMENT_HEADERS RCVSH,

3787: WHERE receipt_num like :1
3788: ORDER BY receipt_num';
3789: */
3790: sql_string := 'SELECT RCVSH.receipt_num, POV.vendor_name
3791: FROM RCV_SHIPMENT_HEADERS RCVSH,
3792: PO_VENDORS POV,
3793: RCV_TRANSACTIONS RT
3794: WHERE RCVSH.RECEIPT_SOURCE_CODE in (''VENDOR'',''CUSTOMER'') AND
3795: RCVSH.VENDOR_ID = POV.VENDOR_ID(+) AND