[Home] [Help]
2368: SELECT v.vendor_id VENDOR_ID,
2369: v.vendor_type_lookup_code VENDOR_TYPE,
2370: fvv.eliminations_id
2371: INTO l_vendor_id,l_vendor_type,l_eliminations_id
2372: FROM rcv_transactions rt,
2373: po_vendors v,
2374: po_headers_all ph,
2375: fv_facts_vendors_v fvv
2376: WHERE rt.po_header_id = to_number(l_reference_2)
3195: SELECT rt.transaction_date,
3196: rcv.receipt_num,
3197: rt.creation_date,
3198: rt.created_by
3199: FROM rcv_transactions rt,
3200: rcv_shipment_headers rcv
3201: WHERE rt.shipment_header_id = rcv.shipment_header_Id
3202: AND TO_CHAR(rt.transaction_id) = p_reference5;
3203: */
3545: 'SELECT rt.'||g_rec_trxn_date_seg||',
3546: rcv.receipt_num,
3547: rt.creation_date,
3548: rt.created_by
3549: FROM rcv_transactions rt,
3550: rcv_shipment_headers rcv
3551: WHERE rt.shipment_header_id = rcv.shipment_header_Id
3552: AND rt.transaction_id = '||to_number(p_reference5) ;
3553:
3572: 'SELECT rt.transaction_date,
3573: rcv.receipt_num,
3574: rt.creation_date,
3575: rt.created_by
3576: FROM rcv_transactions rt,
3577: rcv_shipment_headers rcv
3578: WHERE rt.shipment_header_id = rcv.shipment_header_Id
3579: AND rt.transaction_id = '||to_number(p_reference5);
3580:
3591: 'SELECT rt.transaction_date,
3592: rcv.receipt_num,
3593: rt.creation_date,
3594: rt.created_by
3595: FROM rcv_transactions rt,
3596: rcv_shipment_headers rcv
3597: WHERE rt.shipment_header_id = rcv.shipment_header_Id
3598: AND rt.transaction_id = '||to_number(p_reference5) ;
3599: OPEN pur_rec FOR l_select ;