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_PACKING_WORKBENCH_PVT dependencies on WMS_PACKING_KITTING_GTEMP

Line 2625: FROM wms_packing_kitting_gtemp

2621:
2622: CURSOR kit_exist_cur IS
2623: SELECT distinct kit_item_id, top_model_line_id, 'Y','N' identified_flag
2624: /*is_kit_identified(kit_item_id) identified_flag*/
2625: FROM wms_packing_kitting_gtemp
2626: WHERE nvl(completed_flag,'N') <> 'Y'
2627: ORDER BY identified_flag desc;
2628:
2629: --in the cursor kit_new_cu We did not use join with WPKG table

Line 2699: (SELECT 1 from WMS_PACKING_KITTING_GTEMP WPKG

2695:
2696: BEGIN
2697: select 1 INTO l_item_in_existing_kit FROM dual
2698: WHERE exists
2699: (SELECT 1 from WMS_PACKING_KITTING_GTEMP WPKG
2700: where WPKG.top_model_line_id = l_kit_rec.top_model_line_id);
2701:
2702: EXCEPTION
2703: WHEN no_data_found THEN

Line 2774: l_kit_rec wms_packing_kitting_gtemp%ROWTYPE;

2770: AND (oel.ato_line_id <> oel.TOP_MODEL_LINE_ID OR oel.ato_line_id IS NULL))
2771: OR (oel1.ato_line_id is not null and oel1.line_id = oel1.top_model_line_id))
2772: ORDER BY oel.top_model_line_id,oel.shippable_flag;
2773:
2774: l_kit_rec wms_packing_kitting_gtemp%ROWTYPE;
2775: l_kit_item_id NUMBER;
2776: l_kit_oqty NUMBER;
2777: BEGIN
2778: IF l_debug = 1 THEN

Line 2801: INSERT INTO wms_packing_kitting_gtemp

2797: l_kit_rec.packed_qty := null;
2798: l_kit_rec.packed_qty_disp := null;
2799: l_kit_rec.completed_flag := 'N';
2800:
2801: INSERT INTO wms_packing_kitting_gtemp
2802: ( ITEM
2803: , kit_item_id
2804: , component_item_id
2805: , top_model_line_id

Line 2859: INSERT INTO wms_packing_kitting_gtemp

2855: END IF;
2856: l_kit_rec.completed_flag := 'N';
2857:
2858:
2859: INSERT INTO wms_packing_kitting_gtemp
2860: ( ITEM
2861: , kit_item_id
2862: , component_item_id
2863: , top_model_line_id

Line 2895: FROM wms_packing_kitting_gtemp

2891: SELECT kit_item_id
2892: ,component_item_id
2893: ,packed_qty
2894: ,packed_qty_disp
2895: FROM wms_packing_kitting_gtemp
2896: WHERE kit_item_id = p_kit_item_id
2897: AND top_model_line_id = p_top_model_line_id
2898: AND component_item_id IS NOT NULL
2899: AND component_item_id <> p_exclude_item_id;

Line 5191: FROM wms_packing_kitting_gtemp

5187: ) IS
5188:
5189: CURSOR c_existing_kits_for_component IS
5190: SELECT DISTINCT top_model_line_id, kit_item_id
5191: FROM wms_packing_kitting_gtemp
5192: WHERE component_item_id = p_component_item_id;
5193:
5194: l_existing_kits_for_component c_existing_kits_for_component%ROWTYPE;
5195: l_kit_packed_qty NUMBER :=0;

Line 5209: FROM wms_packing_kitting_gtemp

5205:
5206: BEGIN
5207: SELECT min(floor(decode(packed_qty_disp, '*',0,NULL,0,to_number(packed_qty_disp))/bom_qty)) kit_qty
5208: INTO l_kit_packed_qty
5209: FROM wms_packing_kitting_gtemp
5210: WHERE kit_item_id = p_kit_item_id
5211: AND top_model_line_id = p_top_model_line_id
5212: AND component_item_id IS NOT NULL;
5213: EXCEPTION

Line 5224: FROM wms_packing_kitting_gtemp

5220:
5221: -- Get Order Qty of the kit
5222: BEGIN
5223: SELECT order_qty INTO l_kit_order_qty
5224: FROM wms_packing_kitting_gtemp
5225: WHERE kit_item_id = p_kit_item_id
5226: AND top_model_line_id = p_top_model_line_id
5227: AND component_item_id IS NULL;
5228: EXCEPTION

Line 5240: UPDATE wms_packing_kitting_gtemp

5236: ELSE
5237: l_completed_flag := 'N';
5238: END IF;
5239:
5240: UPDATE wms_packing_kitting_gtemp
5241: SET packed_qty = l_kit_packed_qty
5242: , packed_qty_disp = decode(l_kit_packed_qty,0,NULL,to_char(l_kit_packed_qty))
5243: , completed_flag = l_completed_flag
5244: WHERE kit_item_id = p_kit_item_id

Line 5249: trace(SQL%ROWCOUNT||' rows of wms_packing_kitting_gtemp updated');

5245: AND top_model_line_id = p_top_model_line_id
5246: AND component_item_id IS NULL;
5247:
5248: IF l_debug = 1 THEN
5249: trace(SQL%ROWCOUNT||' rows of wms_packing_kitting_gtemp updated');
5250: END IF;
5251:
5252: UPDATE wms_packing_kitting_gtemp
5253: SET completed_flag = l_completed_flag

Line 5252: UPDATE wms_packing_kitting_gtemp

5248: IF l_debug = 1 THEN
5249: trace(SQL%ROWCOUNT||' rows of wms_packing_kitting_gtemp updated');
5250: END IF;
5251:
5252: UPDATE wms_packing_kitting_gtemp
5253: SET completed_flag = l_completed_flag
5254: WHERE kit_item_id = p_kit_item_id
5255: AND top_model_line_id = p_top_model_line_id;
5256: IF l_debug = 1 THEN

Line 5257: trace(SQL%ROWCOUNT||' rows of wms_packing_kitting_gtemp updated for completed_flag of '||l_completed_flag);

5253: SET completed_flag = l_completed_flag
5254: WHERE kit_item_id = p_kit_item_id
5255: AND top_model_line_id = p_top_model_line_id;
5256: IF l_debug = 1 THEN
5257: trace(SQL%ROWCOUNT||' rows of wms_packing_kitting_gtemp updated for completed_flag of '||l_completed_flag);
5258: END IF;
5259:
5260:
5261: ELSE

Line 5286: FROM wms_packing_kitting_gtemp

5282: l_kit_packed_qty := 0;
5283: BEGIN
5284: SELECT min(floor(decode(packed_qty_disp, '*',0,NULL,0,to_number(packed_qty_disp))/bom_qty)) kit_qty
5285: INTO l_kit_packed_qty
5286: FROM wms_packing_kitting_gtemp
5287: WHERE kit_item_id = l_existing_kits_for_component.kit_item_id
5288: AND top_model_line_id = l_existing_kits_for_component.top_model_line_id
5289: AND component_item_id IS NOT NULL;
5290: EXCEPTION

Line 5301: FROM wms_packing_kitting_gtemp

5297:
5298: -- Get Order Qty of the kit
5299: BEGIN
5300: SELECT order_qty INTO l_kit_order_qty
5301: FROM wms_packing_kitting_gtemp
5302: WHERE kit_item_id = l_existing_kits_for_component.kit_item_id
5303: AND top_model_line_id = l_existing_kits_for_component.top_model_line_id
5304: AND component_item_id IS NULL;
5305: EXCEPTION

Line 5317: UPDATE wms_packing_kitting_gtemp

5313: ELSE
5314: l_completed_flag := 'N';
5315: END IF;
5316:
5317: UPDATE wms_packing_kitting_gtemp
5318: SET packed_qty = l_kit_packed_qty
5319: , packed_qty_disp = decode(l_kit_packed_qty,0,NULL,to_char(l_kit_packed_qty))
5320: , completed_flag = l_completed_flag
5321: WHERE kit_item_id = l_existing_kits_for_component.kit_item_id

Line 5326: trace(SQL%ROWCOUNT||' rows of wms_packing_kitting_gtemp updated');

5322: AND top_model_line_id = l_existing_kits_for_component.top_model_line_id
5323: AND component_item_id IS NULL;
5324:
5325: IF l_debug = 1 THEN
5326: trace(SQL%ROWCOUNT||' rows of wms_packing_kitting_gtemp updated');
5327: END IF;
5328:
5329: UPDATE wms_packing_kitting_gtemp
5330: SET completed_flag = l_completed_flag

Line 5329: UPDATE wms_packing_kitting_gtemp

5325: IF l_debug = 1 THEN
5326: trace(SQL%ROWCOUNT||' rows of wms_packing_kitting_gtemp updated');
5327: END IF;
5328:
5329: UPDATE wms_packing_kitting_gtemp
5330: SET completed_flag = l_completed_flag
5331: WHERE kit_item_id = l_existing_kits_for_component.kit_item_id
5332: AND top_model_line_id = l_existing_kits_for_component.top_model_line_id;
5333:

Line 5335: trace(SQL%ROWCOUNT||' rows of wms_packing_kitting_gtemp updated for completed_flag of '||l_completed_flag);

5331: WHERE kit_item_id = l_existing_kits_for_component.kit_item_id
5332: AND top_model_line_id = l_existing_kits_for_component.top_model_line_id;
5333:
5334: IF l_debug = 1 THEN
5335: trace(SQL%ROWCOUNT||' rows of wms_packing_kitting_gtemp updated for completed_flag of '||l_completed_flag);
5336: END IF;
5337:
5338: END LOOP;
5339: END IF;

Line 5367: SELECT packed_qty,order_qty,kit_item_id,component_item_id,top_model_line_id FROM wms_packing_kitting_gtemp

5363: l_packed_qty NUMBER;
5364: l_packed_qty_disp VARCHAR2(200);
5365:
5366: CURSOR c_update_QTY_common_comp IS
5367: SELECT packed_qty,order_qty,kit_item_id,component_item_id,top_model_line_id FROM wms_packing_kitting_gtemp
5368: WHERE component_item_id = p_component_item_id
5369: AND ((packed_qty <> order_qty AND packed_qty IS NOT NULL) OR
5370: packed_qty IS NULL);
5371:

Line 5377: FROM wms_packing_kitting_gtemp;

5373: --for debug only
5374: CURSOR c_debug_cur IS
5375: SELECT
5376: packed_qty,order_qty,kit_item_id,component_item_id,top_model_line_id,packed_qty_disp
5377: FROM wms_packing_kitting_gtemp;
5378:
5379: l_debug_cur C_debug_cur%ROWTYPE;
5380: */
5381:

Line 5398: UPDATE wms_packing_kitting_gtemp

5394: trace(' p_action='||p_action);
5395: END IF;
5396:
5397: IF p_kit_item_id IS NOT NULL AND p_component_item_id IS NOT NULL then
5398: UPDATE wms_packing_kitting_gtemp
5399: SET packed_qty = least(order_qty,decode(p_action, 'A', nvl(packed_qty,0) + p_packed_qty, p_packed_qty))
5400: , packed_qty_disp = Decode(p_disp_packed_qty, '*', '*', NULL, NULL,
5401: to_char(least(order_qty,decode(p_action, 'A', nvl(packed_qty,0) + p_packed_qty, p_packed_qty))))
5402: WHERE kit_item_id = p_kit_item_id

Line 5483: UPDATE wms_packing_kitting_gtemp

5479:
5480:
5481: IF l_surplus_qty <= 0 THEN
5482:
5483: UPDATE wms_packing_kitting_gtemp
5484: SET packed_qty = (l_remaining_qty_to_pack+l_update_qty_common_comp.packed_qty)
5485: --, packed_qty_disp = '*'
5486: WHERE kit_item_id = l_update_qty_common_comp.kit_item_id
5487: AND component_item_id = l_update_qty_common_comp.component_item_id

Line 5504: UPDATE wms_packing_kitting_gtemp

5500:
5501: l_remaining_qty_to_pack := l_remaining_qty_to_pack -
5502: (l_update_qty_common_comp.order_qty - l_update_qty_common_comp.packed_qty);
5503:
5504: UPDATE wms_packing_kitting_gtemp
5505: SET packed_qty = l_update_qty_common_comp.order_qty
5506: --, packed_qty_disp = '*'
5507: WHERE kit_item_id = l_update_qty_common_comp.kit_item_id
5508: AND component_item_id = l_update_qty_common_comp.component_item_id

Line 5519: UPDATE wms_packing_kitting_gtemp

5515: END IF;
5516:
5517: END LOOP;
5518:
5519: UPDATE wms_packing_kitting_gtemp
5520: SET packed_qty_disp = '*'
5521: WHERE component_item_id = p_component_item_id;
5522:
5523: END IF;

Line 5560: SELECT packed_qty,kit_item_id,component_item_id,top_model_line_id FROM wms_packing_kitting_gtemp

5556: */
5557:
5558:
5559: CURSOR c_update_disp_qty_common_comp IS
5560: SELECT packed_qty,kit_item_id,component_item_id,top_model_line_id FROM wms_packing_kitting_gtemp
5561: WHERE component_item_id = p_inventory_item_id
5562: AND packed_qty = order_qty
5563: AND packed_qty IS NOT NULL;
5564:

Line 5881: FROM wms_packing_kitting_gtemp

5877: /*
5878: --FOR DEBUG ONLY
5879: BEGIN
5880: SELECT SUM(packed_qty), SUM(order_qty) INTO l_pack_comp_qty_total,l_ord_comp_qty_total
5881: FROM wms_packing_kitting_gtemp
5882: WHERE component_item_id = p_inventory_item_id
5883: GROUP BY component_item_id;
5884: EXCEPTION
5885: WHEN no_data_found THEN

Line 5900: FROM wms_packing_kitting_gtemp

5896:
5897: BEGIN
5898: SELECT 1 INTO l_common_qty_filled FROM dual WHERE exists
5899: (SELECT 1
5900: FROM wms_packing_kitting_gtemp
5901: WHERE component_item_id = p_inventory_item_id
5902: AND ((packed_qty <> order_qty AND packed_qty IS NOT
5903: NULL) OR (packed_qty IS NULL) ));
5904:

Line 5926: UPDATE wms_packing_kitting_gtemp

5922: CLOSE c_update_disp_qty_common_comp;
5923: EXIT;
5924: END IF;
5925:
5926: UPDATE wms_packing_kitting_gtemp
5927: SET packed_qty_disp = l_update_disp_qty_common_comp.packed_qty
5928: WHERE kit_item_id = l_update_disp_qty_common_comp.kit_item_id
5929: AND component_item_id = l_update_disp_qty_common_comp.component_item_id
5930: AND top_model_line_id = l_update_disp_qty_common_comp.top_model_line_id;

Line 5967: SELECT 1 FROM wms_packing_kitting_gtemp

5963: BEGIN
5964: SELECT 1 INTO l_exist
5965: FROM dual
5966: WHERE exists(
5967: SELECT 1 FROM wms_packing_kitting_gtemp
5968: WHERE kit_item_id = p_kit_id
5969: AND component_item_id IS NOT NULL
5970: AND packed_qty IS NOT NULL
5971: AND packed_qty_disp = '*');

Line 5990: SELECT COUNT(1) INTO l_cnt FROM wms_packing_kitting_gtemp

5986: l_cnt NUMBER := 0;
5987: BEGIN
5988:
5989: BEGIN
5990: SELECT COUNT(1) INTO l_cnt FROM wms_packing_kitting_gtemp
5991: WHERE component_item_id = p_component_id;
5992: EXCEPTION
5993: WHEN no_data_found THEN
5994: l_cnt := 0; --is not there, unique