DBA Data[Home] [Help]

APPS.QA_PLAN_ELEMENT_API dependencies on RCV_TRANSACTIONS

Line 2475: RCV_TRANSACTIONS RT

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
2479: receipt_num = x_receipt_number;

Line 3925: RCV_TRANSACTIONS RT

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
3929: rcvsh.receipt_num like :1