DBA Data[Home] [Help]

APPS.WSH_PURGE dependencies on WSH_PURGE_SET_V

Line 304: Description: This API gets all the Shipping Data from the view WSH_PURGE_SET_V

300: x_tbl_trip_stops_purge_set - pl/sql table of trip stop id's eligible for purge
301: x_tbl_containers_purge_set - pl/sql table of container id's eligible for purge
302: x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
303:
304: Description: This API gets all the Shipping Data from the view WSH_PURGE_SET_V
305: and puts it into the plsql tables for respective entities after validating it
306: with the user given parameters
307: ==============================================================================
308: Input: Parameters as given in the FDD.

Line 507: wsh_purge_set_v outer

503: --construct trip_sql
504: trip_sql := 'SELECT
505: trip_id,trip_name,''NON_EMPTY'' purge_set_type
506: FROM
507: wsh_purge_set_v outer
508: GROUP BY trip_id,trip_name
509: HAVING count(outer.dd_id) = (SELECT count(inner.dd_id)
510: FROM
511: wsh_purge_set_v inner ';

Line 511: wsh_purge_set_v inner ';

507: wsh_purge_set_v outer
508: GROUP BY trip_id,trip_name
509: HAVING count(outer.dd_id) = (SELECT count(inner.dd_id)
510: FROM
511: wsh_purge_set_v inner ';
512: --check whether FTE is installed
513: IF (wsh_util_core.fte_is_installed='Y') THEN
514: trip_sql := trip_sql || ',fte_invoice_headers fih ' ;
515: END IF;

Line 2097: FROM wsh_purge_set_v

2093: del_pickup_date,
2094: del_dropoff_date,
2095: del_ship_date,
2096: bol
2097: FROM wsh_purge_set_v
2098: WHERE trip_id = p_tripid;
2099:
2100: --Added hints to the query for bug 4891951
2101: CURSOR c_bols_for_del(p_delivery_id NUMBER) IS

Line 2103: FROM wsh_purge_set_v v

2099:
2100: --Added hints to the query for bug 4891951
2101: CURSOR c_bols_for_del(p_delivery_id NUMBER) IS
2102: SELECT /*+use_nl(v.wda, v.wnd, v.wdl)*/ distinct v.bol
2103: FROM wsh_purge_set_v v
2104: WHERE v.del_id = p_delivery_id
2105: AND v.bol is not null;
2106:
2107: --Get Sales Order Details for Deliveries

Line 2113: FROM wsh_purge_set_v v

2109: CURSOR c_so_for_delivery(p_delivery_id NUMBER) IS
2110: SELECT /*+use_nl(v.wda, v.wnd, v.wdl)*/ DISTINCT v.dd_source_header_number,
2111: v.dd_source_header_type_name--,
2112: -- dd_creation_date
2113: FROM wsh_purge_set_v v
2114: WHERE v.del_id = p_delivery_id
2115: AND v.dd_source_header_number is not null;
2116:
2117: CURSOR c_dels_trips_for_order(p_ordernumber VARCHAR2) IS

Line 2130: FROM wsh_purge_set_v

2126: del_pickup_date,
2127: del_dropoff_date,
2128: del_ship_date,
2129: bol
2130: FROM wsh_purge_set_v
2131: WHERE dd_source_header_number= p_ordernumber;
2132:
2133: --Get Containers for Sales Orders
2134: /*CURSOR c_containers_for_so(order_number varchar2) IS