DBA Data[Home] [Help]

APPS.OE_BLANKET_UTIL dependencies on OE_INVOICE_TO_ORGS_V

Line 212: From oe_invoice_to_orgs_v

208: IF g_customer_relations = 'N' THEN
209:
210: Select 'VALID'
211: Into l_dummy
212: From oe_invoice_to_orgs_v
213: Where customer_id = p_sold_to_org_id
214: And site_use_id = p_invoice_to_org_id
215: and status='A'
216: and address_status ='A';

Line 9392: from oe_invoice_to_orgs_v

9388: if mc1x.invoice_to_org_id is not null then
9389: -- Invoice To
9390: BEGIN
9391: Select 'VALID' Into l_dummy
9392: from oe_invoice_to_orgs_v
9393: Where customer_id = p_sold_to_org_id
9394: AND site_use_id = mc1x.invoice_to_org_id;
9395: EXCEPTION
9396: WHEN NO_DATA_FOUND THEN