DBA Data[Home] [Help]

APPS.PO_COO_S dependencies on PO_APPROVED_SUPPLIER_LIS_VAL_V

Line 13: FROM po_approved_supplier_lis_val_v pasl,

9: x_country_of_origin IN OUT NOCOPY VARCHAR2) IS
10:
11: CURSOR C is
12: SELECT paa.country_of_origin_code
13: FROM po_approved_supplier_lis_val_v pasl,
14: po_asl_attributes paa
15: WHERE pasl.item_id = x_item_id
16: AND pasl.vendor_id = x_vendor_id
17: AND nvl(pasl.vendor_site_id, -1) = nvl(x_vendor_site_id, -1)