APPS.MST_AGG_PKG dependencies on FTE_LOCATION_PARAMETERS

Line 2136: FROM fte_location_parameters fte

2132: CURSOR customer_facilities IS
2133: SELECT fte.location_id customer_facility_id,
2134: fte.facility_code facility_code,
2135: fte.description description
2136: FROM fte_location_parameters fte
2137: WHERE fte.location_id IN
2138: (SELECT DECODE(mdd.source_code, OE , mdd.ship_to_location_id,
2139: RFC, mdd.ship_from_location_id) location_id
2140: FROM mst_delivery_details mdd

Line 2149: from mst_delivery_details, fte_location_parameters fte

2145: select distinct decode(source_code, OE, ship_to_location_id,
2146: RFC, ship_from_location_id) customer_facility_id,
2147: fte.facility_code facility_code,
2148: fte.description description
2149: from mst_delivery_details, fte_location_parameters fte
2150: where plan_id = p_plan_id
2151: and customer_id = p_customer_id
2152: and source_code in (OE, RFC)
2153: and decode(source_code, RFC, ship_from_location_id, ship_to_location_id) = fte.location_id;*/

Line 2177: FROM fte_location_parameters fte

2173: CURSOR supplier_facilities is
2174: SELECT fte.location_id supplier_facility_id,
2175: fte.facility_code facility_code,
2176: fte.description description
2177: FROM fte_location_parameters fte
2178: WHERE fte.location_id in
2179: (SELECT DECODE(mdd.source_code, RTV, mdd.ship_to_location_id,
2180: PO, mdd.ship_from_location_id) location_id
2181: FROM mst_delivery_details mdd

Line 2190: from mst_delivery_details, fte_location_parameters fte

2186: select distinct decode(source_code, RTV, ship_to_location_id,
2187: PO, ship_from_location_id) supplier_facility_id,
2188: fte.facility_code facility_code,
2189: fte.description description
2190: from mst_delivery_details, fte_location_parameters fte
2191: where plan_id = p_plan_id
2192: and supplier_id = p_supplier_id
2193: and source_code in (PO, RTV)
2194: and decode(source_code, RTV, ship_to_location_id, PO, ship_from_location_id) = fte.location_id;*/