APPS.OE_CNCL_VALIDATE_HEADER dependencies on OE_INVOICE_TO_ORGS_V

Line 341: FROM oe_invoice_to_orgs_v

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

Line 349: FROM oe_invoice_to_orgs_v oito

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

Line 868: From oe_invoice_to_orgs_v

864: IF nvl(lcustomer_relations,'N') = 'N' THEN
865:
866: Select 'VALID'
867: Into l_dummy
868: From oe_invoice_to_orgs_v
869: Where customer_id = p_header_rec.sold_to_org_id
870: AND site_use_id = p_header_rec.invoice_to_org_id;
871: ELSIF lcustomer_relations = 'Y' THEN
872:

Line 875: From oe_invoice_to_orgs_v

871: ELSIF lcustomer_relations = 'Y' THEN
872:
873: /*Select /*MOAC_SQL_NO_CHANGE 'VALID'
874: Into l_dummy
875: From oe_invoice_to_orgs_v
876: WHERE site_use_id = p_header_rec.invoice_to_org_id
877: AND
878: customer_id in (
879: Select p_header_rec.sold_to_org_id from dual

Line 909: From oe_invoice_to_orgs_v

905: ('Cr: A',2);
906:
907: SELECT 'VALID'
908: INTO l_dummy
909: From oe_invoice_to_orgs_v
910: WHERE site_use_id = p_header_rec.invoice_to_org_id
911: AND ROWNUM = 1;
912:
913: