APPS.OE_CNCL_VALIDATE_LINE dependencies on OE_SHIP_TO_ORGS_V

Line 857: FROM oe_ship_to_orgs_v

853: lcustomer_relations varchar2(1);
854: --bug 4729536
855: Cursor cur_customer_relations IS
856: SELECT 'VALID'
857: FROM oe_ship_to_orgs_v
858: WHERE site_use_id = p_ship_to_org_id
859: AND status = 'A'
860: AND customer_id = p_sold_to_org_id
861: AND ROWNUM = 1

Line 866: FROM oe_ship_to_orgs_v osto

862:
863: UNION ALL
864:
865: SELECT /*MOAC_SQL_NO_CHANGE*/ 'VALID'
866: FROM oe_ship_to_orgs_v osto
867: WHERE site_use_id = p_ship_to_org_id
868: AND status = 'A'
869: AND EXISTS
870: (

Line 891: From oe_ship_to_orgs_v

887: IF nvl(lcustomer_relations,'N') = 'N' THEN
888:
889: Select 'VALID'
890: Into l_dummy
891: From oe_ship_to_orgs_v
892: Where customer_id = p_sold_to_org_id
893: AND site_use_id = p_ship_to_org_id
894: AND status = 'A';
895:

Line 902: From oe_ship_to_orgs_v

898: ELSIF lcustomer_relations = 'Y' THEN
899:
900: /*Select /*MOAC_SQL_NO_CHANGE 'VALID'
901: Into l_dummy
902: From oe_ship_to_orgs_v
903: WHERE site_use_id = p_ship_to_org_id
904: AND status = 'A' AND
905: customer_id in (
906: Select p_sold_to_org_id from dual

Line 933: FROM oe_ship_to_orgs_v

929: ('Cr: A',2);
930:
931: SELECT 'VALID'
932: INTO l_dummy
933: FROM oe_ship_to_orgs_v
934: WHERE site_use_id = p_ship_to_org_id
935: AND ROWNUM = 1;
936:
937: END IF;