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.WMS_WAVE_PLANNING_PVT dependencies on WMS_WP_WAVE_HEADERS_VL

Line 553: delete from wms_wp_wave_headers_vl

549: is
550:
551: begin
552:
553: delete from wms_wp_wave_headers_vl
554: where wave_header_id = p_wave_header_id;
555:
556: commit;
557:

Line 696: from wms_wp_wave_headers_vl

692: p_plan_wave,
693: p_release_wave,
694: p_carrier_id,
695: p_category_id
696: from wms_wp_wave_headers_vl
697: where wave_header_id = v_wave_header_id;
698:
699: set_global_variable(p_order_type_id,
700: p_order_header_id,

Line 723: update wms_wp_wave_headers_vl

719: p_customer_class_id,
720: p_carrier_id,
721: p_category_id);
722:
723: update wms_wp_wave_headers_vl
724: set request_id = fnd_global.conc_request_id
725: where wave_header_id = v_wave_header_id;
726:
727: --Call the Dynamic SQL

Line 965: INSERT INTO wms_wp_wave_headers_vl

961: begin
962:
963: select WMS_WP_WAVE_HEADERS_S.NEXTVAL into l_wave_header_id from dual;
964:
965: INSERT INTO wms_wp_wave_headers_vl
966: (wave_header_id,
967: WAVE_NAME,
968: WAVE_DESCRIPTION,
969: start_time, -- start time changes

Line 1116: FROM wms_wp_wave_headers_vl

1112: CROSS_DOCK_CRITERIA,
1113: PLANNING_CRITERIA,
1114: PLANNING_CRITERIA_ID,
1115: pick_subinventory
1116: FROM wms_wp_wave_headers_vl
1117: WHERE wave_header_id = p_wave_header_id;
1118:
1119: INSERT INTO wms_wp_Advanced_Criteria
1120: (RULE_ID,

Line 1958: FROM wms_wp_wave_headers_vl

1954: if v_destination_subinventory is null THEN
1955:
1956: SELECT staging_subinventory
1957: INTO v_destination_subinventory
1958: FROM wms_wp_wave_headers_vl
1959: WHERE wave_header_id = p_wave_header_id;
1960:
1961: end if;
1962:

Line 2318: from wms_wp_wave_headers_vl wwh,

2314: wdd.inventory_item_id,
2315: (wdd.requested_quantity - nvl(wwr.allocated_quantity, 0)) requested_quantity,
2316: wdd.requested_quantity_uom,
2317: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) demand_source_header_id
2318: from wms_wp_wave_headers_vl wwh,
2319: wms_wp_wave_lines wwl, --11775489 get from wdd... FIXED
2320: wms_wp_planning_criteria_vl wwp,
2321: wsh_delivery_details wdd,
2322: wms_wp_rules_simulation wwr

Line 5089: from wms_wp_wave_headers_vl wwh,

5085: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) demand_source_header_id,
5086: -- wdd.source_header_type_id,
5087: decode(wdd.source_document_type_id, 10, 8, 2) demand_source_type_id,
5088: wwl.wave_line_id
5089: from wms_wp_wave_headers_vl wwh,
5090: wms_wp_wave_lines wwl, --11775489 get from wdd... FIXED...may have performance impact...
5091: wms_wp_planning_criteria_vl wwp,
5092: wsh_delivery_details wdd
5093: where wwh.wave_header_id = p_wave_header_id

Line 5325: FROM wms_wp_wave_headers_vl

5321: g_staging_subinventory,
5322: g_to_locator,
5323: l_wave_status,
5324: l_pull_replenishment
5325: FROM wms_wp_wave_headers_vl
5326: WHERE wave_header_id = p_wave_header_id;
5327:
5328: print_debug('Ajith after', l_debug);
5329: print_Debug('start time = ' ||

Line 7226: FROM wms_wp_wave_headers_vl

7222:
7223: -- start time changes start
7224: SELECT start_time
7225: INTO l_start_date
7226: FROM wms_wp_wave_headers_vl
7227: WHERE wave_header_id = p_wave_header_id;
7228: print_debug('start_time = ' || l_start_date, l_debug);
7229:
7230: -- start time changes end

Line 7826: from wms_wp_wave_headers_vl

7822: end if;
7823:
7824: select pull_replenishment_flag
7825: into v_replenishment_required
7826: from wms_wp_wave_headers_vl
7827: where wave_header_id = p_wave_header_id;
7828:
7829: if l_att >= L_DEMAND_QTY then
7830:

Line 8044: SELECT organization_id INTO l_org_id FROM wms_Wp_Wave_headers_vl WHERE wave_header_id=p_wave_header_id;

8040: end if;
8041:
8042: if l_allocation_method = 'C' then
8043:
8044: SELECT organization_id INTO l_org_id FROM wms_Wp_Wave_headers_vl WHERE wave_header_id=p_wave_header_id;
8045:
8046: labor_resource_planning(c_labor_time_tbl,
8047: 1,
8048: 'A',

Line 8917: update wms_wp_wave_headers_vl

8913: and wwl.organization_id = wdd.organization_id
8914: and nvl(remove_from_wave_flag, 'N') <> 'Y')
8915: and wave_header_id <> p_wave_header_id;
8916:
8917: update wms_wp_wave_headers_vl
8918: set wave_firmed_flag = 'Y'
8919: where wave_header_id = p_wave_header_id;
8920:
8921: -- commit;

Line 8934: /* update wms_wp_wave_headers_vl

8930: X_BATCH_ID => p_BATCH_ID);
8931:
8932: print_debug('Value of p batch id is' || p_batch_id, l_debug);
8933:
8934: /* update wms_wp_wave_headers_vl
8935: set request_id = p_request_id
8936: where wave_header_id = p_wave_header_id;*/
8937:
8938: --Making our concurrent program wait till the pick release concurrent program is complete

Line 11408: p_wave_header_rec in wms_wp_wave_headers_vl%ROWTYPE) is

11404: l_debug);
11405: END SET_ACTION_TASKS_PARAMETERS;
11406:
11407: PROCEDURE insert_wave_header(x_return_status OUT nocopy VARCHAR2,
11408: p_wave_header_rec in wms_wp_wave_headers_vl%ROWTYPE) is
11409: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
11410: p_WAVE_NAME VARCHAR2(4000);
11411: begin
11412:

Line 11413: -- delete from wms_wp_wave_headers_vl where wave_header_id = p_wave_header_id ;

11409: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
11410: p_WAVE_NAME VARCHAR2(4000);
11411: begin
11412:
11413: -- delete from wms_wp_wave_headers_vl where wave_header_id = p_wave_header_id ;
11414: --check if the wave header already exists.
11415: -- For appending wave name with wave header id
11416:
11417: savepoint wave_header_creation;

Line 11431: insert into wms_wp_wave_headers_vl

11427:
11428: end if;
11429: print_debug('Concurrent Request Id' || fnd_global.conc_request_id,
11430: l_debug);
11431: insert into wms_wp_wave_headers_vl
11432: (WAVE_HEADER_ID,
11433: WAVE_NAME,
11434: WAVE_DESCRIPTION,
11435: start_time, -- start time changes

Line 11772: from wms_wp_wave_headers_vl

11768: p_RELEASE_IMMEDIATELY,
11769: p_pick_subinventory,
11770: p_crossdock_criteria_name,
11771: p_append_flag -- ssk
11772: from wms_wp_wave_headers_vl
11773: where wave_header_id = p_wave_header_id;
11774:
11775: /* Leave out parameters other than in Wave Options tab
11776: if p_FROM_ORDER_HEADER_ID is not null then

Line 12123: from wms_wp_wave_headers_vl

12119: if p_plan_wave = 'Y' then
12120:
12121: select planning_criteria_id
12122: into p_planning_criteria_id
12123: from wms_wp_wave_headers_vl
12124: where wave_header_id = p_wave_header_id;
12125:
12126: print_debug('In Launch Online Plan Wave with Planning Criteria Id ' ||
12127: p_planning_criteria_id,

Line 12168: update wms_wp_wave_headers_vl

12164: and wwl.organization_id = wdd.organization_id
12165: and nvl(remove_from_wave_flag, 'N') <> 'Y')
12166: and wave_header_id <> p_wave_header_id;
12167:
12168: update wms_wp_wave_headers_vl
12169: set wave_firmed_flag = 'Y'
12170: where wave_header_id = p_wave_header_id;
12171:
12172: print_debug('In Launch Online Before Calling Release Wave',

Line 12287: wms_wp_wave_headers_vl headers

12283: SELECT restrictions.PARAMETER_ID,
12284: restrictions.OPERATOR_MEANING,
12285: restrictions.OPERAND_VALUE
12286: FROM WMS_WP_ADVANCED_CRITERIA restrictions,
12287: wms_wp_wave_headers_vl headers
12288: WHERE restrictions.RULE_WAVE_HEADER_ID = headers.wave_header_id
12289: and restrictions.RULE_WAVE_HEADER_ID = P_WAVE_HEADER_ID
12290: AND PARAMETER_ID IN (6002, 6003, 6004, 6005, 6006);
12291:

Line 12297: wms_wp_wave_headers_vl headers

12293: SELECT restrictions.PARAMETER_ID,
12294: restrictions.OPERATOR_MEANING,
12295: restrictions.OPERAND_VALUE
12296: FROM WMS_WP_ADVANCED_CRITERIA restrictions,
12297: wms_wp_wave_headers_vl headers
12298: WHERE restrictions.RULE_WAVE_HEADER_ID = headers.wave_header_id
12299: and restrictions.RULE_WAVE_HEADER_ID = P_WAVE_HEADER_ID
12300: AND PARAMETER_ID = 6001;
12301:

Line 12308: from wms_wp_wave_headers_vl

12304: print_debug('Entered Get Dynamic SQL ' || l_return_status, l_debug);
12305:
12306: select advanced_criteria, nvl(wave_firmed_flag, 'N')
12307: into v_advanced_sql, l_firmed_flag
12308: from wms_wp_wave_headers_vl
12309: where wave_header_id = p_wave_header_id;
12310:
12311: OPEN get_default_params(org_id);
12312: FETCH get_default_params

Line 12949: wms_wp_wave_headers_vl wwh

12945: WHERE l_custom_line_tbl(i)
12946: .delivery_detail_id IN
12947: (SELECT distinct wwl.delivery_detail_id
12948: FROM WMS_WP_WAVE_LINES wwl,
12949: wms_wp_wave_headers_vl wwh
12950: WHERE wwl.wave_header_id = p_wave_header_id -- Bug 13448469 (Replaced 367 with p_wave_header_id)
12951: OR (wwl.wave_header_id = wwh.wave_header_id and
12952: nvl(wwh.wave_firmed_flag, 'N') = 'Y' and
12953: wwh.wave_status <> 'Cancelled' and

Line 13243: '(SELECT distinct wwl.delivery_detail_id FROM WMS_WP_WAVE_LINES wwl ,wms_wp_wave_headers_vl wwh, wsh_delivery_details wdd

13239: ' AND WTS.STOP_ID = WDO.TRIP_STOP(+) ' || --Added for Dock Assignments
13240: ' AND NVL(WDD.REQUESTED_QUANTITY,0) > 0' ||
13241: ' AND WDD.SOURCE_CODE = ''OE''' ||
13242: ' AND WDD.DELIVERY_DETAIL_ID NOT IN' || --11775489 get from wdd... FIXED
13243: '(SELECT distinct wwl.delivery_detail_id FROM WMS_WP_WAVE_LINES wwl ,wms_wp_wave_headers_vl wwh, wsh_delivery_details wdd
13244: where wwl.wave_header_id=wwh.wave_header_id and wwl.delivery_detail_id = wdd.delivery_detail_id
13245: and wwl.organization_id = wdd.organization_id and (nvl(wwh.wave_firmed_flag,''N'') = ''Y'' and wwh.wave_status <> ''Cancelled'' and nvl(wwl.remove_from_wave_flag,''N'') <>''Y''))';
13246: -- WHERE WAVE_HEADER_ID = :X_WAVE_HEADER_ID)';
13247:

Line 13865: from wms_wp_planning_criteria_vl wwp, wms_wp_wave_headers_vl wwh

13861: -- Checking if Pick Subinventory is mentioned in Planning Criteria
13862: begin
13863: select picking_subinventory
13864: into l_pick_subinventory
13865: from wms_wp_planning_criteria_vl wwp, wms_wp_wave_headers_vl wwh
13866: where wave_header_id = p_wave_header_id
13867: and wwh.planning_Criteria_id = wwp.planning_Criteria_id;
13868: print_debug('pick_subinventory :' || l_pick_subinventory, l_debug);
13869: exception

Line 14279: update wms_wp_wave_headers_vl

14275: begin
14276:
14277: IF(p_batch_id is not NULL) THEN
14278: print_debug('Update Wave Header Status 2: ' || Status ||'the val of batch'||p_batch_id, l_debug);
14279: update wms_wp_wave_headers_vl
14280: set wave_status = Status,
14281: batch_id = p_batch_id
14282: where wave_header_id = p_wave_header_id;
14283:

Line 14286: update wms_wp_wave_headers_vl

14282: where wave_header_id = p_wave_header_id;
14283:
14284: ELSE
14285: print_debug('Update Wave Header Status 3: ' || Status ||'the val of batch'||p_batch_id, l_debug);
14286: update wms_wp_wave_headers_vl
14287: set wave_status = Status
14288: where wave_header_id = p_wave_header_id;
14289:
14290: END IF; --end if for batch_id != NULL

Line 15254: from wms_wp_wave_headers_vl wwh,

15250: --Cursor to find whether the wave lines in Released Status are staged.
15251:
15252: cursor c_waves is
15253: select wwh.wave_header_id
15254: from wms_wp_wave_headers_vl wwh,
15255: (select wave_header_id, count(1) count_lines
15256: from wms_wp_wwb_lines_v
15257: where nvl(remove_from_wave_flag, 'N') = 'N'
15258: group by wave_header_id) wwlv,

Line 15285: update wms_wp_wave_headers_vl

15281: print_debug('Completion Status for Wave : ' ||
15282: l_waves.wave_header_id,
15283: l_debug);
15284:
15285: update wms_wp_wave_headers_vl
15286: set wave_status = 'Completed', wave_Completion_time = sysdate -- should we change the column name to Wave Completion Date
15287: where wave_header_id = l_waves.wave_header_id;
15288:
15289: update wms_wp_wave_lines

Line 15343: from wms_wp_wave_headers_vl wwh,

15339: is
15340: -- Cursor change to the base table and compare wave line count with lines in wdd status shipped in a wave. Ajith?????
15341: cursor c_completed_waves is
15342: select wwh.wave_header_id
15343: from wms_wp_wave_headers_vl wwh,
15344: (select wave_header_id, count(1) count_lines
15345: from wms_wp_wwb_lines_v
15346: where nvl(remove_from_wave_flag, 'N') = 'N'
15347: group by wave_header_id) wwlv,

Line 15377: update wms_wp_wave_headers_vl

15373:
15374: -- commit;
15375: if l_wave_header_tbl.count > 0 then
15376: forall k in l_wave_header_tbl.FIRST .. l_wave_header_tbl.LAST
15377: update wms_wp_wave_headers_vl
15378: set wave_status = 'Closed' -- should we change the column name to Wave Completion Date
15379: where wave_header_id = l_wave_header_tbl(k);
15380:
15381: end if;

Line 15411: wms_wp_wave_headers_vl wwh,

15407: -- Transaction Qty should be converted to primary uom
15408: cursor c_lines is
15409: select wwl.wave_line_id
15410: from wms_wp_wave_lines wwl, --11775489 added org_id join...
15411: wms_wp_wave_headers_vl wwh,
15412: wsh_delivery_details wdd
15413: where wwh.wave_header_id = wwl.wave_header_id
15414: and (wwh.wave_status = 'Released')
15415: and nvl(wwl.remove_from_wave_flag, 'N') = 'N'

Line 15514: FROM wms_wp_wave_headers_vl

15510: wdd.date_scheduled))))) date_scheduled
15511: FROM wms_wp_wave_lines wwl, --11775489 added org_id join...
15512: wsh_delivery_details wdd,
15513: (SELECT wave_header_id wave_id
15514: FROM wms_wp_wave_headers_vl
15515: WHERE ((wave_header_id = p_wave) AND
15516: LOWER(wave_status) in ('released', 'completed'))
15517: OR (p_wave IS NULL AND
15518: LOWER(wave_status) in ('released', 'completed'))) wwh,

Line 19267: wms_wp_wave_headers_vl wwl

19263: wls.total_capacity,
19264: wpl.time_uom
19265: from wms_wp_labor_statistics wls,
19266: wms_wp_planning_criteria_vl wpl,
19267: wms_wp_wave_headers_vl wwl
19268: WHERE wwl.wave_header_id = p_wave_header_id
19269: and wls.wave_header_id = wwl.wave_header_id
19270: AND wpl.planning_criteria_id = wwl.planning_criteria_id;
19271:

Line 19298: wms_wp_wave_headers_vl wwh

19294: into l_pick_fill_rate
19295: from wms_wp_wave_lines wwl,
19296: wsh_delivery_details wdd,
19297: wms_wp_wwb_tasks_v wwtv,
19298: wms_wp_wave_headers_vl wwh
19299: where wwl.wave_line_id = p_wave_line_id
19300: and wwl.delivery_detail_id = wdd.delivery_detail_id
19301: and wwl.organization_id = wdd.organization_id
19302: and wwtv.transaction_source_line_id(+) = wdd.source_line_id

Line 19450: INSERT INTO wms_wp_wave_headers_vl

19446: l_debug);
19447:
19448: x_return_status := 'S';
19449: x_wave_header_id := l_wave_header_id;
19450: INSERT INTO wms_wp_wave_headers_vl
19451: (wave_header_id,
19452: WAVE_NAME,
19453: WAVE_DESCRIPTION,
19454: start_time, -- start time changes

Line 19664: update wms_wp_wave_headers_vl

19660: IS
19661:
19662: BEGIN
19663:
19664: update wms_wp_wave_headers_vl
19665: set release_immediately = 'Y'
19666: WHERE WAVE_HEADER_ID = P_WAVE_HEADER_ID;
19667:
19668: /*UPDATE wms_wp_wave_lines

Line 19676: update wms_wp_wave_headers_vl

19672: (SELECT delivery_detail_id FROM wms_wp_wave_lines WHERE wave_header_id = p_wave_header_id
19673: and nvl(remove_from_wave_flag,'N')<>'Y')
19674: and wave_header_id != p_wave_header_id;
19675:
19676: update wms_wp_wave_headers_vl
19677: set wave_firmed_flag = 'Y'
19678: where wave_header_id = p_wave_header_id;
19679: */
19680: commit;