[Home] [Help]
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;
2060: CAR_SITES.TENDER_WAIT_TIME SHIPPER_WAIT_TIME,
2061: CAR_SITES.WAIT_TIME_UOM WAIT_TIME_UOM,
2062: CAR_SITES.AUTO_ACCEPT_LOAD_TENDER AUTO_ACCEPT_LOAD_TENDER
2063: FROM
2064: HZ_PARTIES PARTY,
2065: HZ_RELATIONSHIPS REL,
2066: HZ_PARTY_SITES SITES,
2067: HZ_ORG_CONTACTS CONT,
2068: HZ_CONTACT_POINTS POINTS,
2071: WSH_LOCATIONS WL
2072: WHERE
2073: REL.OBJECT_ID = PARTY.PARTY_ID
2074: AND REL.SUBJECT_TYPE = 'ORGANIZATION'
2075: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2076: AND SITES.PARTY_ID = REL.SUBJECT_ID
2077: AND CONT.PARTY_SITE_ID = SITES.PARTY_SITE_ID
2078: AND CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
2079: AND POINTS.OWNER_TABLE_ID = REL.PARTY_ID
2076: AND SITES.PARTY_ID = REL.SUBJECT_ID
2077: AND CONT.PARTY_SITE_ID = SITES.PARTY_SITE_ID
2078: AND CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
2079: AND POINTS.OWNER_TABLE_ID = REL.PARTY_ID
2080: AND POINTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
2081: AND POINTS.CONTACT_POINT_TYPE = 'EMAIL'
2082: --AND PHONE.OWNER_TABLE_ID(+) = REL.PARTY_ID
2083: --AND PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
2084: --AND PHONE.CONTACT_POINT_TYPE(+) = 'PHONE'
2079: AND POINTS.OWNER_TABLE_ID = REL.PARTY_ID
2080: AND POINTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
2081: AND POINTS.CONTACT_POINT_TYPE = 'EMAIL'
2082: --AND PHONE.OWNER_TABLE_ID(+) = REL.PARTY_ID
2083: --AND PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
2084: --AND PHONE.CONTACT_POINT_TYPE(+) = 'PHONE'
2085: AND CAR_SITES.CARRIER_SITE_ID = SITES.PARTY_SITE_ID
2086: AND WL.WSH_LOCATION_ID = SITES.LOCATION_ID
2087: AND (DECODE(CAR_SITES.EMAIL_ADDRESS, POINTS.EMAIL_ADDRESS,'Y','N') = 'Y'
2095: CAR_SITES.TENDER_WAIT_TIME SHIPPER_WAIT_TIME,
2096: CAR_SITES.WAIT_TIME_UOM WAIT_TIME_UOM,
2097: CAR_SITES.AUTO_ACCEPT_LOAD_TENDER AUTO_ACCEPT_LOAD_TENDER
2098: FROM
2099: HZ_PARTIES PARTY,
2100: HZ_RELATIONSHIPS REL,
2101: HZ_PARTY_SITES SITES,
2102: HZ_ORG_CONTACTS CONT,
2103: HZ_CONTACT_POINTS POINTS,
2107: WSH_ORG_CARRIER_SITES ORG_CAR_SITES
2108: WHERE
2109: REL.OBJECT_ID = PARTY.PARTY_ID
2110: AND REL.SUBJECT_TYPE = 'ORGANIZATION'
2111: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2112: AND SITES.PARTY_ID = REL.SUBJECT_ID
2113: AND CONT.PARTY_SITE_ID = SITES.PARTY_SITE_ID
2114: AND CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
2115: AND POINTS.OWNER_TABLE_ID = REL.PARTY_ID
2112: AND SITES.PARTY_ID = REL.SUBJECT_ID
2113: AND CONT.PARTY_SITE_ID = SITES.PARTY_SITE_ID
2114: AND CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
2115: AND POINTS.OWNER_TABLE_ID = REL.PARTY_ID
2116: AND POINTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
2117: AND POINTS.CONTACT_POINT_TYPE = 'EMAIL'
2118: --AND PHONE.OWNER_TABLE_ID(+) = REL.PARTY_ID
2119: --AND PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
2120: --AND PHONE.CONTACT_POINT_TYPE(+) = 'PHONE'
2115: AND POINTS.OWNER_TABLE_ID = REL.PARTY_ID
2116: AND POINTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
2117: AND POINTS.CONTACT_POINT_TYPE = 'EMAIL'
2118: --AND PHONE.OWNER_TABLE_ID(+) = REL.PARTY_ID
2119: --AND PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
2120: --AND PHONE.CONTACT_POINT_TYPE(+) = 'PHONE'
2121: AND CAR_SITES.CARRIER_SITE_ID = SITES.PARTY_SITE_ID
2122: AND WL.WSH_LOCATION_ID = SITES.LOCATION_ID
2123: AND (DECODE(CAR_SITES.EMAIL_ADDRESS, POINTS.EMAIL_ADDRESS,'Y','N') = 'Y'