DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB dependencies on PO_VENDOR_CONTACTS

Line 1838: PO_VENDOR_CONTACTS C

1834: C.LAST_NAME name
1835: FROM
1836: JTF_RS_RESOURCE_EXTNS RSC ,
1837: PO_VENDOR_SITES_ALL S ,
1838: PO_VENDOR_CONTACTS C
1839: WHERE
1840: RSC.CATEGORY = 'SUPPLIER_CONTACT'
1841: AND C.VENDOR_CONTACT_ID = RSC.SOURCE_ID
1842: AND S.VENDOR_SITE_ID = C.VENDOR_SITE_ID

Line 3234: PO_VENDOR_CONTACTS C

3230: okc_contacts_v con,
3231: okc_k_party_roles_b pty ,
3232: JTF_RS_RESOURCE_EXTNS RSC ,
3233: PO_VENDOR_SITES_ALL S ,
3234: PO_VENDOR_CONTACTS C
3235: where
3236: pty.cle_id = to_number(p_bus_proc_ID_arg)
3237: and pty.dnz_chr_id = to_number(p_contract_ID_arg)
3238: and con.cpl_id = pty.id