[Home] [Help]
2282: SELECT v.vendor_id VENDOR_ID,
2283: v.vendor_type_lookup_code VENDOR_TYPE,
2284: fvv.eliminations_id
2285: INTO l_vendor_id,l_vendor_type,l_eliminations_id
2286: FROM rcv_transactions rt,
2287: po_vendors v,
2288: po_headers_all ph,
2289: fv_facts_vendors_v fvv
2290: WHERE rt.po_header_id = to_number(l_reference_2)
2981: SELECT rt.transaction_date,
2982: rcv.receipt_num,
2983: rt.creation_date,
2984: rt.created_by
2985: FROM rcv_transactions rt,
2986: rcv_shipment_headers rcv
2987: WHERE rt.shipment_header_id = rcv.shipment_header_Id
2988: AND TO_CHAR(rt.transaction_id) = p_reference5;
2989: */
3337: 'SELECT rt.'||g_rec_trxn_date_seg||',
3338: rcv.receipt_num,
3339: rt.creation_date,
3340: rt.created_by
3341: FROM rcv_transactions rt,
3342: rcv_shipment_headers rcv
3343: WHERE rt.shipment_header_id = rcv.shipment_header_Id
3344: AND rt.transaction_id = '||to_number(p_reference5) ;
3345:
3364: 'SELECT rt.transaction_date,
3365: rcv.receipt_num,
3366: rt.creation_date,
3367: rt.created_by
3368: FROM rcv_transactions rt,
3369: rcv_shipment_headers rcv
3370: WHERE rt.shipment_header_id = rcv.shipment_header_Id
3371: AND rt.transaction_id = '||to_number(p_reference5);
3372:
3383: 'SELECT rt.transaction_date,
3384: rcv.receipt_num,
3385: rt.creation_date,
3386: rt.created_by
3387: FROM rcv_transactions rt,
3388: rcv_shipment_headers rcv
3389: WHERE rt.shipment_header_id = rcv.shipment_header_Id
3390: AND rt.transaction_id = '||to_number(p_reference5) ;
3391: OPEN pur_rec FOR l_select ;