APPS.OKL_CREDIT_DATAPOINTS_PVT dependencies on PO_VENDORS

Line 158: OKC_K_PARTY_ROLES_B CPL, PO_VENDORS PO

154: BEGIN
155: SELECT PO.SEGMENT1
156: INTO l_program_vendor
157: FROM OKL_LEASE_APPLICATIONS_B LAP, OKC_K_HEADERS_B CHR,
158: OKC_K_PARTY_ROLES_B CPL, PO_VENDORS PO
159: WHERE LAP.PROGRAM_AGREEMENT_ID = CHR.ID
160: AND CHR.ID = CPL.DNZ_CHR_ID
161: AND CPL.JTOT_OBJECT1_CODE = 'OKL_VENDOR'
162: AND CPL.OBJECT1_ID1 = PO.VENDOR_ID

Line 625: FROM PO_VENDORS VENDOR, OKL_ASSET_COMPONENTS_B ASSET_COMP,

621: CURSOR cItemSupp IS
622: -- ssdeshpa Bug# 6689249 start
623: SELECT VENDOR.VENDOR_NAME SUPPLIER
624: -- ssdeshpa Bug# 6689249 end
625: FROM PO_VENDORS VENDOR, OKL_ASSET_COMPONENTS_B ASSET_COMP,
626: OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
627: OKL_LEASE_QUOTES_B QUOTE
628: WHERE VENDOR.VENDOR_ID = ASSET_COMP.SUPPLIER_ID
629: AND ASSET_COMP.ASSET_ID = ASSET.ID

Line 1268: FROM PO_VENDORS VENDOR, OKL_ASSET_COMPONENTS_B ASSET_COMP

1264: l_add_on_item_supplier VARCHAR2(30);
1265:
1266: CURSOR cItemSupplier IS
1267: SELECT VENDOR.VENDOR_NAME ITEM_SUPPLIER
1268: FROM PO_VENDORS VENDOR, OKL_ASSET_COMPONENTS_B ASSET_COMP
1269: WHERE VENDOR.VENDOR_ID = ASSET_COMP.SUPPLIER_ID
1270: AND ASSET_COMP.ASSET_ID = l_asset_id
1271: AND ASSET_COMP.PRIMARY_COMPONENT = 'NO';
1272: