DBA Data[Home] [Help]

APPS.OE_BLANKET_UTIL dependencies on OE_INVOICE_TO_ORGS_V

Line 301: From oe_invoice_to_orgs_v

297: IF g_customer_relations = 'N' THEN
298:
299: Select 'VALID'
300: Into l_dummy
301: From oe_invoice_to_orgs_v
302: Where customer_id = p_sold_to_org_id
303: And site_use_id = p_invoice_to_org_id
304: and status='A'
305: and address_status ='A';

Line 9589: from oe_invoice_to_orgs_v

9585: if mc1x.invoice_to_org_id is not null then
9586: -- Invoice To
9587: BEGIN
9588: Select 'VALID' Into l_dummy
9589: from oe_invoice_to_orgs_v
9590: Where customer_id = p_sold_to_org_id
9591: AND site_use_id = mc1x.invoice_to_org_id;
9592: EXCEPTION
9593: WHEN NO_DATA_FOUND THEN