DBA Data[Home] [Help]

APPS.QA_PLAN_ELEMENT_API dependencies on RCV_TRANSACTIONS

Line 2451: RCV_TRANSACTIONS RT

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
2454: RT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID AND
2455: receipt_num = x_receipt_number;

Line 3793: RCV_TRANSACTIONS RT

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
3796: RT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID AND
3797: rcvsh.receipt_num like :1