APPS.FV_GTAS_TRX_REGISTER dependencies on RCV_TRANSACTIONS

Line 2952: FROM rcv_transactions rt,

2948: SELECT v.vendor_id VENDOR_ID,
2949: NVL(v.global_attribute4,'N') vendor_type,
2950: substr(v.global_attribute5,1,3)
2951: INTO l_vendor_id,l_vendor_type,l_eliminations_id
2952: FROM rcv_transactions rt,
2953: po_vendors v,
2954: po_headers_all ph
2955: WHERE rt.po_header_id = to_number(l_reference_2)
2956: AND rt.transaction_id = to_number(l_reference_5)

Line 3678: FROM rcv_transactions rt,

3674: 'SELECT rt.'||g_rec_trxn_date_seg||',
3675: rcv.receipt_num,
3676: rt.creation_date,
3677: rt.created_by
3678: FROM rcv_transactions rt,
3679: rcv_shipment_headers rcv
3680: WHERE rt.shipment_header_id = rcv.shipment_header_Id
3681: AND rt.transaction_id = '||to_number(p_reference5) ;
3682:

Line 3704: FROM rcv_transactions rt,

3700: 'SELECT rt.transaction_date,
3701: rcv.receipt_num,
3702: rt.creation_date,
3703: rt.created_by
3704: FROM rcv_transactions rt,
3705: rcv_shipment_headers rcv
3706: WHERE rt.shipment_header_id = rcv.shipment_header_Id
3707: AND rt.transaction_id = '||to_number(p_reference5);
3708:

Line 3723: FROM rcv_transactions rt,

3719: 'SELECT rt.transaction_date,
3720: rcv.receipt_num,
3721: rt.creation_date,
3722: rt.created_by
3723: FROM rcv_transactions rt,
3724: rcv_shipment_headers rcv
3725: WHERE rt.shipment_header_id = rcv.shipment_header_Id
3726: AND rt.transaction_id = '||to_number(p_reference5) ;
3727: OPEN pur_rec FOR l_select ;