DBA Data[Home] [Help]

APPS.ECEPOI dependencies on OE_INVOICE_TO_ORGS_V

Line 217: FROM oe_invoice_to_orgs_v

213: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG',l_orgid);
214: If nvl(lcustomer_relations ,'N') = 'N' Then
215: SELECT site_use_id
216: INTO l_site_use_id
217: FROM oe_invoice_to_orgs_v
218: WHERE customer_id = p_customer_id
219: AND address_id = p_address_id
220: AND status = 'A'; --12645675 - Condition to check if the Site Usage is Active;
221: ELSIF lcustomer_relations = 'Y' THEN

Line 224: From oe_invoice_to_orgs_v

220: AND status = 'A'; --12645675 - Condition to check if the Site Usage is Active;
221: ELSIF lcustomer_relations = 'Y' THEN
222: SELECT site_use_id
223: INTO l_site_use_id
224: From oe_invoice_to_orgs_v
225: WHERE address_id = p_address_id
226: AND status = 'A' --12645675 - Condition to check if the Site Usage is Active
227: AND
228: customer_id in (