APPS.OE_CNCL_VALIDATE_HEADER dependencies on OE_INVOICE_TO_ORGS_V

Line 342: FROM oe_invoice_to_orgs_v

338: AND ROWNUM = 1;
339:
340: Cursor Cur_customer_relations_inv IS
341: SELECT /*MOAC_SQL_NO_CHANGE*/ 'VALID'
342: FROM oe_invoice_to_orgs_v
343: WHERE site_use_id = p_header_rec.invoice_to_org_id
344: AND customer_id = p_header_rec.sold_to_org_id
345: AND ROWNUM = 1
346:

Line 350: FROM oe_invoice_to_orgs_v oito

346:
347: UNION ALL
348:
349: SELECT /*MOAC_SQL_NO_CHANGE*/ 'VALID'
350: FROM oe_invoice_to_orgs_v oito
351: WHERE oito.site_use_id = p_header_rec.invoice_to_org_id
352: AND EXISTS(
353: SELECT 1 FROM
354: HZ_CUST_ACCT_RELATE hcar WHERE

Line 899: From oe_invoice_to_orgs_v

895: IF nvl(lcustomer_relations,'N') = 'N' THEN
896:
897: Select 'VALID'
898: Into l_dummy
899: From oe_invoice_to_orgs_v
900: Where customer_id = p_header_rec.sold_to_org_id
901: AND site_use_id = p_header_rec.invoice_to_org_id;
902: ELSIF lcustomer_relations = 'Y' THEN
903:

Line 906: From oe_invoice_to_orgs_v

902: ELSIF lcustomer_relations = 'Y' THEN
903:
904: /*Select /*MOAC_SQL_NO_CHANGE 'VALID'
905: Into l_dummy
906: From oe_invoice_to_orgs_v
907: WHERE site_use_id = p_header_rec.invoice_to_org_id
908: AND
909: customer_id in (
910: Select p_header_rec.sold_to_org_id from dual

Line 940: From oe_invoice_to_orgs_v

936: ('Cr: A',2);
937:
938: SELECT 'VALID'
939: INTO l_dummy
940: From oe_invoice_to_orgs_v
941: WHERE site_use_id = p_header_rec.invoice_to_org_id
942: AND ROWNUM = 1;
943:
944: