eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_MLS_UTIL dependencies on WSH_ORG_CARRIER_SITES

Line 2517: FROM WSH_ORG_CARRIER_SITES org_sites,

2513:
2514: CURSOR GET_VENDOR_SITE_ID_FOR_TRIP(l_organization_id NUMBER) IS
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

Line 2530: sites.supplier_site_id), car.currency_code FROM WSH_ORG_CARRIER_SITES org_sites,

2526:
2527:
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

Line 2544: FROM WSH_ORG_CARRIER_SITES org_sites,

2540:
2541: CURSOR GET_VENDOR_SITE_ID_FOR_CARRIER(l_organization_id NUMBER, l_carrier_id NUMBER) IS
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

Line 2557: WSH_ORG_CARRIER_SITES org_sites,

2553:
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

Line 2849: FROM WSH_ORG_CARRIER_SITES org_sites,

2845: CURSOR GET_VENDOR_SITE_ID_FOR_TRIP(l_organization_id NUMBER,l_entity_id NUMBER) IS
2846: SELECT decode(sites.supplier_site_id,null,car.supplier_site_id,
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

Line 2864: FROM WSH_ORG_CARRIER_SITES org_sites,

2860: CURSOR GET_VENDOR_SITE_ID_FOR_DLVY(l_entity_id NUMBER) IS
2861: SELECT decode(sites.supplier_site_id,null,car.supplier_site_id,
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