APPS.OE_CNCL_VALIDATE_HEADER dependencies on OE_SHIP_TO_ORGS_V

Line 321: FROM oe_ship_to_orgs_v

317:
318: --bug 4729536
319: Cursor Cur_Customer_Relations IS
320: SELECT /*MOAC_SQL_NO_CHANGE*/ 'VALID'
321: FROM oe_ship_to_orgs_v
322: WHERE site_use_id = p_header_rec.ship_to_org_id
323: AND customer_id = p_header_rec.sold_to_org_id
324: AND ROWNUM = 1
325:

Line 329: FROM oe_ship_to_orgs_v osov

325:
326: UNION ALL
327:
328: SELECT /*MOAC_SQL_NO_CHANGE*/ 'VALID'
329: FROM oe_ship_to_orgs_v osov
330: WHERE site_use_id = p_header_rec.ship_to_org_id
331: AND EXISTS
332: (SELECT 1 FROM
333: HZ_CUST_ACCT_RELATE hcar

Line 716: FROM oe_ship_to_orgs_v

712: ('Cr: No',2);
713:
714: SELECT 'VALID'
715: INTO l_dummy
716: FROM oe_ship_to_orgs_v
717: WHERE customer_id = p_header_rec.sold_to_org_id
718: AND site_use_id = p_header_rec.ship_to_org_id
719: AND ROWNUM = 1;
720: --

Line 731: From oe_ship_to_orgs_v

727: ('Cr: Yes',2);
728:
729: /*Select /*MOAC_SQL_NO_CHANGE 'VALID'
730: Into l_dummy
731: From oe_ship_to_orgs_v
732: WHERE site_use_id = p_header_rec.ship_to_org_id
733: AND
734: customer_id in (
735: Select p_header_rec.sold_to_org_id from dual

Line 766: FROM oe_ship_to_orgs_v

762: ('Cr: A',2);
763:
764: SELECT 'VALID'
765: INTO l_dummy
766: FROM oe_ship_to_orgs_v
767: WHERE site_use_id = p_header_rec.ship_to_org_id
768: AND ROWNUM = 1;
769:
770: