316:
317: --bug 4729536
318: Cursor Cur_Customer_Relations IS
319: SELECT /*MOAC_SQL_NO_CHANGE*/ 'VALID'
320: FROM oe_ship_to_orgs_v
321: WHERE site_use_id = p_header_rec.ship_to_org_id
322: AND customer_id = p_header_rec.sold_to_org_id
323: AND ROWNUM = 1
324:
324:
325: UNION ALL
326:
327: SELECT /*MOAC_SQL_NO_CHANGE*/ 'VALID'
328: FROM oe_ship_to_orgs_v osov
329: WHERE site_use_id = p_header_rec.ship_to_org_id
330: AND EXISTS
331: (SELECT 1 FROM
332: HZ_CUST_ACCT_RELATE hcar
681: ('Cr: No',2);
682:
683: SELECT 'VALID'
684: INTO l_dummy
685: FROM oe_ship_to_orgs_v
686: WHERE customer_id = p_header_rec.sold_to_org_id
687: AND site_use_id = p_header_rec.ship_to_org_id
688: AND ROWNUM = 1;
689: --
696: ('Cr: Yes',2);
697:
698: /*Select /*MOAC_SQL_NO_CHANGE 'VALID'
699: Into l_dummy
700: From oe_ship_to_orgs_v
701: WHERE site_use_id = p_header_rec.ship_to_org_id
702: AND
703: customer_id in (
704: Select p_header_rec.sold_to_org_id from dual
731: ('Cr: A',2);
732:
733: SELECT 'VALID'
734: INTO l_dummy
735: FROM oe_ship_to_orgs_v
736: WHERE site_use_id = p_header_rec.ship_to_org_id
737: AND ROWNUM = 1;
738:
739: