DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on PO_APPROVED_SUPPLIER_LIS_VAL_V

Line 911: FROM po_approved_supplier_lis_val_v

907:
908: IF (x_supply_agreement_flag <> 'N') THEN
909: SELECT NVL(MAX('found'), 'notfound')
910: INTO x_success
911: FROM po_approved_supplier_lis_val_v
912: WHERE vendor_id = x_asl_record.vendor_id
913: AND vendor_site_id = x_asl_record.vendor_site_id
914: AND item_id = x_asl_record.item_id
915: AND ( using_organization_id = NVL(x_asl_record.to_organization_id, using_organization_id)