DBA Data[Home] [Help]

APPS.CSP_REPAIR_PO_GRP dependencies on PO_VENDORS

Line 241: from po_vendors

237: --------------------------------------------
238: Begin
239: Select VENDOR_NAME
240: into l_VENDOR_NAME
241: from po_vendors
242: where vendor_id = P_repair_supplier_id
243: --and nvl(start_date_active,sysdate) <= nvl(end_date_active,sysdate);
244: and NVL(START_DATE_ACTIVE,SYSDATE) <= SYSDATE
245: and NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE;

Line 292: from po_vendors a, hr_organization_information b

288: Get Vendor Id based on Repair supplier Organization Id
289: -------------------------------------------------------
290: Begin
291: select a.vendor_id
292: from po_vendors a, hr_organization_information b
293: where b.organization_id = 3201 --> P_repair_supplier_org_id (Repair supplier Org Id parameter)
294: and a.vendor_id = b.ORG_INFORMATION3
295: and b.ORG_INFORMATION_CONTEXT = 'Customer/Supplier Association'
296: and NVL(a.START_DATE_ACTIVE,SYSDATE) <= SYSDATE