APPS.FTE_MLS_UTIL dependencies on WSH_CARRIERS

Line 1403: FROM hz_parties hz, wsh_carriers wc

1399: --{
1400: CURSOR get_carrier_name_cur(c_carrier_id NUMBER)
1401: IS
1402: SELECT hz.party_name name
1403: FROM hz_parties hz, wsh_carriers wc
1404: WHERE hz.party_id = wc.carrier_id
1405: AND wc.carrier_id = c_carrier_id;
1406: --}
1407: BEGIN

Line 2519: WSH_CARRIERS car, wsh_trips trips

2515: SELECT decode(sites.supplier_site_id,null,car.supplier_site_id,
2516: sites.supplier_site_id), car.currency_code
2517: FROM WSH_ORG_CARRIER_SITES org_sites,
2518: WSH_CARRIER_SITES sites,
2519: WSH_CARRIERS car, wsh_trips trips
2520: WHERE org_sites.ORGANIZATION_ID = l_organization_id
2521: AND sites.carrier_site_id = org_sites.carrier_site_id
2522: AND sites.carrier_id = car.carrier_id
2523: AND car.CARRIER_ID = trips.carrier_id

Line 2532: WSH_CARRIERS car, wsh_new_deliveries del

2528: CURSOR GET_VENDOR_SITE_ID_FOR_DLVY IS
2529: SELECT decode(sites.supplier_site_id,null,car.supplier_site_id,
2530: sites.supplier_site_id), car.currency_code FROM WSH_ORG_CARRIER_SITES org_sites,
2531: WSH_CARRIER_SITES sites,
2532: WSH_CARRIERS car, wsh_new_deliveries del
2533: WHERE org_sites.ORGANIZATION_ID = del.organization_id
2534: AND sites.carrier_site_id = org_sites.carrier_site_id
2535: AND sites.carrier_id = car.carrier_id
2536: AND car.CARRIER_ID = del.carrier_id

Line 2546: WSH_CARRIERS car

2542: SELECT decode(sites.supplier_site_id,null,car.supplier_site_id,
2543: sites.supplier_site_id), car.currency_code
2544: FROM WSH_ORG_CARRIER_SITES org_sites,
2545: WSH_CARRIER_SITES sites,
2546: WSH_CARRIERS car
2547: WHERE org_sites.ORGANIZATION_ID = l_organization_id
2548: AND sites.carrier_site_id = org_sites.carrier_site_id
2549: AND sites.carrier_id = car.carrier_id
2550: AND org_sites.ENABLED_FLAG = 'Y'

Line 2558: WSH_CARRIERS car

2554: CURSOR GET_CARRIER_SITE(l_organization_id NUMBER, l_carrier_id NUMBER) IS
2555: SELECT sites.carrier_site_id, sites.supplier_site_id
2556: FROM WSH_CARRIER_SITES sites,
2557: WSH_ORG_CARRIER_SITES org_sites,
2558: WSH_CARRIERS car
2559: WHERE org_sites.ORGANIZATION_ID = l_organization_id
2560: AND sites.carrier_site_id = org_sites.carrier_site_id
2561: AND sites.carrier_id = car.carrier_id
2562: AND org_sites.ENABLED_FLAG = 'Y'

Line 2714: FROM WSH_CARRIERS WHERE CARRIER_ID = l_carrier_id;

2710: THEN
2711: -- Get the default supplier and supplier site
2712: SELECT SUPPLIER_ID,SUPPLIER_SITE_ID,CURRENCY_CODE
2713: INTO l_vendor_id,l_vendor_site_id,l_carrier_currency
2714: FROM WSH_CARRIERS WHERE CARRIER_ID = l_carrier_id;
2715: END IF;
2716:
2717:
2718: IF (l_vendor_site_id IS NOT NULL)

Line 2851: WSH_CARRIERS car, wsh_trips trips

2847: sites.supplier_site_id), car.currency_code,
2848: car.supplier_id,sites.carrier_site_id
2849: FROM WSH_ORG_CARRIER_SITES org_sites,
2850: WSH_CARRIER_SITES sites,
2851: WSH_CARRIERS car, wsh_trips trips
2852: WHERE org_sites.ORGANIZATION_ID = l_organization_id
2853: AND sites.carrier_site_id = org_sites.carrier_site_id
2854: AND sites.carrier_id = car.carrier_id
2855: AND car.CARRIER_ID = trips.carrier_id

Line 2866: WSH_CARRIERS car, wsh_new_deliveries del

2862: sites.supplier_site_id), car.currency_code,car.supplier_id,
2863: sites.carrier_site_id
2864: FROM WSH_ORG_CARRIER_SITES org_sites,
2865: WSH_CARRIER_SITES sites,
2866: WSH_CARRIERS car, wsh_new_deliveries del
2867: WHERE org_sites.ORGANIZATION_ID = del.organization_id
2868: AND sites.carrier_site_id = org_sites.carrier_site_id
2869: AND sites.carrier_id = car.carrier_id
2870: AND car.CARRIER_ID = del.carrier_id