DBA Data[Home] [Help]

APPS.FTE_MLS_WRAPPER dependencies on WSH_CARRIER_SITES

Line 1806: FROM WSH_CARRIER_SITES sites, HZ_PARTIES parties

1802:
1803: CURSOR c_isCarrierTenderEnabled (p_CarrierID NUMBER) IS
1804: SELECT 'Y', decode(ENABLE_AUTO_TENDER,null,'N','N','N','Y') AUTO_TENDER,
1805: party_name carrier_name
1806: FROM WSH_CARRIER_SITES sites, HZ_PARTIES parties
1807: WHERE CARRIER_ID = p_CarrierID
1808: AND parties.party_id = carrier_id
1809: AND (sites.EMAIL_ADDRESS IS NOT NULL OR TENDER_TRANSMISSION_METHOD IS NOT NULL)
1810: AND ROWNUM = 1;

Line 2070: WSH_CARRIER_SITES CAR_SITES,

2066: HZ_PARTY_SITES SITES,
2067: HZ_ORG_CONTACTS CONT,
2068: HZ_CONTACT_POINTS POINTS,
2069: --HZ_CONTACT_POINTS PHONE,
2070: WSH_CARRIER_SITES CAR_SITES,
2071: WSH_LOCATIONS WL
2072: WHERE
2073: REL.OBJECT_ID = PARTY.PARTY_ID
2074: AND REL.SUBJECT_TYPE = 'ORGANIZATION'

Line 2105: WSH_CARRIER_SITES CAR_SITES,

2101: HZ_PARTY_SITES SITES,
2102: HZ_ORG_CONTACTS CONT,
2103: HZ_CONTACT_POINTS POINTS,
2104: --HZ_CONTACT_POINTS PHONE,
2105: WSH_CARRIER_SITES CAR_SITES,
2106: WSH_LOCATIONS WL,
2107: WSH_ORG_CARRIER_SITES ORG_CAR_SITES
2108: WHERE
2109: REL.OBJECT_ID = PARTY.PARTY_ID