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 2552: FROM wms_packing_kitting_gtemp

2548:
2549: CURSOR kit_exist_cur IS
2550: SELECT distinct kit_item_id, top_model_line_id, 'Y','N' identified_flag
2551: /*is_kit_identified(kit_item_id) identified_flag*/
2552: FROM wms_packing_kitting_gtemp
2553: WHERE nvl(completed_flag,'N') <> 'Y'
2554: ORDER BY identified_flag desc;
2555:
2556: --in the cursor kit_new_cu We did not use join with WPKG table

Line 2626: (SELECT 1 from WMS_PACKING_KITTING_GTEMP WPKG

2622:
2623: BEGIN
2624: select 1 INTO l_item_in_existing_kit FROM dual
2625: WHERE exists
2626: (SELECT 1 from WMS_PACKING_KITTING_GTEMP WPKG
2627: where WPKG.top_model_line_id = l_kit_rec.top_model_line_id);
2628:
2629: EXCEPTION
2630: WHEN no_data_found THEN

Line 2701: l_kit_rec wms_packing_kitting_gtemp%ROWTYPE;

2697: AND (oel.ato_line_id <> oel.TOP_MODEL_LINE_ID OR oel.ato_line_id IS NULL))
2698: OR (oel1.ato_line_id is not null and oel1.line_id = oel1.top_model_line_id))
2699: ORDER BY oel.top_model_line_id,oel.shippable_flag;
2700:
2701: l_kit_rec wms_packing_kitting_gtemp%ROWTYPE;
2702: l_kit_item_id NUMBER;
2703: l_kit_oqty NUMBER;
2704: BEGIN
2705: IF l_debug = 1 THEN

Line 2728: INSERT INTO wms_packing_kitting_gtemp

2724: l_kit_rec.packed_qty := null;
2725: l_kit_rec.packed_qty_disp := null;
2726: l_kit_rec.completed_flag := 'N';
2727:
2728: INSERT INTO wms_packing_kitting_gtemp
2729: ( ITEM
2730: , kit_item_id
2731: , component_item_id
2732: , top_model_line_id

Line 2786: INSERT INTO wms_packing_kitting_gtemp

2782: END IF;
2783: l_kit_rec.completed_flag := 'N';
2784:
2785:
2786: INSERT INTO wms_packing_kitting_gtemp
2787: ( ITEM
2788: , kit_item_id
2789: , component_item_id
2790: , top_model_line_id

Line 2822: FROM wms_packing_kitting_gtemp

2818: SELECT kit_item_id
2819: ,component_item_id
2820: ,packed_qty
2821: ,packed_qty_disp
2822: FROM wms_packing_kitting_gtemp
2823: WHERE kit_item_id = p_kit_item_id
2824: AND top_model_line_id = p_top_model_line_id
2825: AND component_item_id IS NOT NULL
2826: AND component_item_id <> p_exclude_item_id;

Line 5025: FROM wms_packing_kitting_gtemp

5021: ) IS
5022:
5023: CURSOR c_existing_kits_for_component IS
5024: SELECT DISTINCT top_model_line_id, kit_item_id
5025: FROM wms_packing_kitting_gtemp
5026: WHERE component_item_id = p_component_item_id;
5027:
5028: l_existing_kits_for_component c_existing_kits_for_component%ROWTYPE;
5029: l_kit_packed_qty NUMBER :=0;

Line 5043: FROM wms_packing_kitting_gtemp

5039:
5040: BEGIN
5041: SELECT min(floor(decode(packed_qty_disp, '*',0,NULL,0,to_number(packed_qty_disp))/bom_qty)) kit_qty
5042: INTO l_kit_packed_qty
5043: FROM wms_packing_kitting_gtemp
5044: WHERE kit_item_id = p_kit_item_id
5045: AND top_model_line_id = p_top_model_line_id
5046: AND component_item_id IS NOT NULL;
5047: EXCEPTION

Line 5058: FROM wms_packing_kitting_gtemp

5054:
5055: -- Get Order Qty of the kit
5056: BEGIN
5057: SELECT order_qty INTO l_kit_order_qty
5058: FROM wms_packing_kitting_gtemp
5059: WHERE kit_item_id = p_kit_item_id
5060: AND top_model_line_id = p_top_model_line_id
5061: AND component_item_id IS NULL;
5062: EXCEPTION

Line 5074: UPDATE wms_packing_kitting_gtemp

5070: ELSE
5071: l_completed_flag := 'N';
5072: END IF;
5073:
5074: UPDATE wms_packing_kitting_gtemp
5075: SET packed_qty = l_kit_packed_qty
5076: , packed_qty_disp = decode(l_kit_packed_qty,0,NULL,to_char(l_kit_packed_qty))
5077: , completed_flag = l_completed_flag
5078: WHERE kit_item_id = p_kit_item_id

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

5079: AND top_model_line_id = p_top_model_line_id
5080: AND component_item_id IS NULL;
5081:
5082: IF l_debug = 1 THEN
5083: trace(SQL%ROWCOUNT||' rows of wms_packing_kitting_gtemp updated');
5084: END IF;
5085:
5086: UPDATE wms_packing_kitting_gtemp
5087: SET completed_flag = l_completed_flag

Line 5086: UPDATE wms_packing_kitting_gtemp

5082: IF l_debug = 1 THEN
5083: trace(SQL%ROWCOUNT||' rows of wms_packing_kitting_gtemp updated');
5084: END IF;
5085:
5086: UPDATE wms_packing_kitting_gtemp
5087: SET completed_flag = l_completed_flag
5088: WHERE kit_item_id = p_kit_item_id
5089: AND top_model_line_id = p_top_model_line_id;
5090: IF l_debug = 1 THEN

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

5087: SET completed_flag = l_completed_flag
5088: WHERE kit_item_id = p_kit_item_id
5089: AND top_model_line_id = p_top_model_line_id;
5090: IF l_debug = 1 THEN
5091: trace(SQL%ROWCOUNT||' rows of wms_packing_kitting_gtemp updated for completed_flag of '||l_completed_flag);
5092: END IF;
5093:
5094:
5095: ELSE

Line 5120: FROM wms_packing_kitting_gtemp

5116: l_kit_packed_qty := 0;
5117: BEGIN
5118: SELECT min(floor(decode(packed_qty_disp, '*',0,NULL,0,to_number(packed_qty_disp))/bom_qty)) kit_qty
5119: INTO l_kit_packed_qty
5120: FROM wms_packing_kitting_gtemp
5121: WHERE kit_item_id = l_existing_kits_for_component.kit_item_id
5122: AND top_model_line_id = l_existing_kits_for_component.top_model_line_id
5123: AND component_item_id IS NOT NULL;
5124: EXCEPTION

Line 5135: FROM wms_packing_kitting_gtemp

5131:
5132: -- Get Order Qty of the kit
5133: BEGIN
5134: SELECT order_qty INTO l_kit_order_qty
5135: FROM wms_packing_kitting_gtemp
5136: WHERE kit_item_id = l_existing_kits_for_component.kit_item_id
5137: AND top_model_line_id = l_existing_kits_for_component.top_model_line_id
5138: AND component_item_id IS NULL;
5139: EXCEPTION

Line 5151: UPDATE wms_packing_kitting_gtemp

5147: ELSE
5148: l_completed_flag := 'N';
5149: END IF;
5150:
5151: UPDATE wms_packing_kitting_gtemp
5152: SET packed_qty = l_kit_packed_qty
5153: , packed_qty_disp = decode(l_kit_packed_qty,0,NULL,to_char(l_kit_packed_qty))
5154: , completed_flag = l_completed_flag
5155: WHERE kit_item_id = l_existing_kits_for_component.kit_item_id

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

5156: AND top_model_line_id = l_existing_kits_for_component.top_model_line_id
5157: AND component_item_id IS NULL;
5158:
5159: IF l_debug = 1 THEN
5160: trace(SQL%ROWCOUNT||' rows of wms_packing_kitting_gtemp updated');
5161: END IF;
5162:
5163: UPDATE wms_packing_kitting_gtemp
5164: SET completed_flag = l_completed_flag

Line 5163: UPDATE wms_packing_kitting_gtemp

5159: IF l_debug = 1 THEN
5160: trace(SQL%ROWCOUNT||' rows of wms_packing_kitting_gtemp updated');
5161: END IF;
5162:
5163: UPDATE wms_packing_kitting_gtemp
5164: SET completed_flag = l_completed_flag
5165: WHERE kit_item_id = l_existing_kits_for_component.kit_item_id
5166: AND top_model_line_id = l_existing_kits_for_component.top_model_line_id;
5167:

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

5165: WHERE kit_item_id = l_existing_kits_for_component.kit_item_id
5166: AND top_model_line_id = l_existing_kits_for_component.top_model_line_id;
5167:
5168: IF l_debug = 1 THEN
5169: trace(SQL%ROWCOUNT||' rows of wms_packing_kitting_gtemp updated for completed_flag of '||l_completed_flag);
5170: END IF;
5171:
5172: END LOOP;
5173: END IF;

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

5197: l_packed_qty NUMBER;
5198: l_packed_qty_disp VARCHAR2(200);
5199:
5200: CURSOR c_update_QTY_common_comp IS
5201: SELECT packed_qty,order_qty,kit_item_id,component_item_id,top_model_line_id FROM wms_packing_kitting_gtemp
5202: WHERE component_item_id = p_component_item_id
5203: AND ((packed_qty <> order_qty AND packed_qty IS NOT NULL) OR
5204: packed_qty IS NULL);
5205:

Line 5211: FROM wms_packing_kitting_gtemp;

5207: --for debug only
5208: CURSOR c_debug_cur IS
5209: SELECT
5210: packed_qty,order_qty,kit_item_id,component_item_id,top_model_line_id,packed_qty_disp
5211: FROM wms_packing_kitting_gtemp;
5212:
5213: l_debug_cur C_debug_cur%ROWTYPE;
5214: */
5215:

Line 5232: UPDATE wms_packing_kitting_gtemp

5228: trace(' p_action='||p_action);
5229: END IF;
5230:
5231: IF p_kit_item_id IS NOT NULL AND p_component_item_id IS NOT NULL then
5232: UPDATE wms_packing_kitting_gtemp
5233: SET packed_qty = least(order_qty,decode(p_action, 'A', nvl(packed_qty,0) + p_packed_qty, p_packed_qty))
5234: , packed_qty_disp = Decode(p_disp_packed_qty, '*', '*', NULL, NULL,
5235: to_char(least(order_qty,decode(p_action, 'A', nvl(packed_qty,0) + p_packed_qty, p_packed_qty))))
5236: WHERE kit_item_id = p_kit_item_id

Line 5317: UPDATE wms_packing_kitting_gtemp

5313:
5314:
5315: IF l_surplus_qty <= 0 THEN
5316:
5317: UPDATE wms_packing_kitting_gtemp
5318: SET packed_qty = (l_remaining_qty_to_pack+l_update_qty_common_comp.packed_qty)
5319: --, packed_qty_disp = '*'
5320: WHERE kit_item_id = l_update_qty_common_comp.kit_item_id
5321: AND component_item_id = l_update_qty_common_comp.component_item_id

Line 5338: UPDATE wms_packing_kitting_gtemp

5334:
5335: l_remaining_qty_to_pack := l_remaining_qty_to_pack -
5336: (l_update_qty_common_comp.order_qty - l_update_qty_common_comp.packed_qty);
5337:
5338: UPDATE wms_packing_kitting_gtemp
5339: SET packed_qty = l_update_qty_common_comp.order_qty
5340: --, packed_qty_disp = '*'
5341: WHERE kit_item_id = l_update_qty_common_comp.kit_item_id
5342: AND component_item_id = l_update_qty_common_comp.component_item_id

Line 5353: UPDATE wms_packing_kitting_gtemp

5349: END IF;
5350:
5351: END LOOP;
5352:
5353: UPDATE wms_packing_kitting_gtemp
5354: SET packed_qty_disp = '*'
5355: WHERE component_item_id = p_component_item_id;
5356:
5357: END IF;

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

5390: */
5391:
5392:
5393: CURSOR c_update_disp_qty_common_comp IS
5394: SELECT packed_qty,kit_item_id,component_item_id,top_model_line_id FROM wms_packing_kitting_gtemp
5395: WHERE component_item_id = p_inventory_item_id
5396: AND packed_qty = order_qty
5397: AND packed_qty IS NOT NULL;
5398:

Line 5715: FROM wms_packing_kitting_gtemp

5711: /*
5712: --FOR DEBUG ONLY
5713: BEGIN
5714: SELECT SUM(packed_qty), SUM(order_qty) INTO l_pack_comp_qty_total,l_ord_comp_qty_total
5715: FROM wms_packing_kitting_gtemp
5716: WHERE component_item_id = p_inventory_item_id
5717: GROUP BY component_item_id;
5718: EXCEPTION
5719: WHEN no_data_found THEN

Line 5734: FROM wms_packing_kitting_gtemp

5730:
5731: BEGIN
5732: SELECT 1 INTO l_common_qty_filled FROM dual WHERE exists
5733: (SELECT 1
5734: FROM wms_packing_kitting_gtemp
5735: WHERE component_item_id = p_inventory_item_id
5736: AND ((packed_qty <> order_qty AND packed_qty IS NOT
5737: NULL) OR (packed_qty IS NULL) ));
5738:

Line 5760: UPDATE wms_packing_kitting_gtemp

5756: CLOSE c_update_disp_qty_common_comp;
5757: EXIT;
5758: END IF;
5759:
5760: UPDATE wms_packing_kitting_gtemp
5761: SET packed_qty_disp = l_update_disp_qty_common_comp.packed_qty
5762: WHERE kit_item_id = l_update_disp_qty_common_comp.kit_item_id
5763: AND component_item_id = l_update_disp_qty_common_comp.component_item_id
5764: AND top_model_line_id = l_update_disp_qty_common_comp.top_model_line_id;

Line 5801: SELECT 1 FROM wms_packing_kitting_gtemp

5797: BEGIN
5798: SELECT 1 INTO l_exist
5799: FROM dual
5800: WHERE exists(
5801: SELECT 1 FROM wms_packing_kitting_gtemp
5802: WHERE kit_item_id = p_kit_id
5803: AND component_item_id IS NOT NULL
5804: AND packed_qty IS NOT NULL
5805: AND packed_qty_disp = '*');

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

5820: l_cnt NUMBER := 0;
5821: BEGIN
5822:
5823: BEGIN
5824: SELECT COUNT(1) INTO l_cnt FROM wms_packing_kitting_gtemp
5825: WHERE component_item_id = p_component_id;
5826: EXCEPTION
5827: WHEN no_data_found THEN
5828: l_cnt := 0; --is not there, unique