DBA Data[Home] [Help]

APPS.FV_GTAS_TRX_REGISTER dependencies on PO_VENDORS

Line 2920: po_vendors v

2916: NVL(v.global_attribute4,'N') vendor_type,
2917: SUBSTR(v.global_attribute5,1,3)
2918: INTO l_vendor_id, l_vendor_type, l_eliminations_id
2919: FROM ap_invoices_all i,
2920: po_vendors v
2921: WHERE i.invoice_id = to_number(l_reference_2)
2922: AND i.vendor_id = v.vendor_id;
2923:
2924: EXCEPTION

Line 2953: po_vendors v,

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)
2957: AND rt.po_header_id = ph.po_header_id

Line 2990: FROM po_vendors pov, po_headers_all poh

2986: SUBSTR(pov.global_attribute5,1,3)
2987: INTO l_vendor_id,
2988: l_vendor_type,
2989: l_eliminations_id
2990: FROM po_vendors pov, po_headers_all poh
2991: WHERE poh.po_header_id = to_number(l_reference_2)
2992: AND pov.vendor_id = poh.vendor_id;
2993: EXCEPTION
2994: WHEN NO_DATA_FOUND THEN

Line 3072: po_vendors v

3068: NVL(v.global_attribute4,'N') vendor_type,
3069: SUBSTR(v.global_attribute5,1,3)
3070: INTO l_vendor_id,l_vendor_type,l_eliminations_id
3071: FROM ap_checks_all apc,
3072: po_vendors v
3073: WHERE apc.vendor_id = v.vendor_id
3074: AND apc.check_id = to_number(l_reference_3);
3075: EXCEPTION
3076: WHEN NO_DATA_FOUND THEN