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_ATF_RUNTIME_PUB_APIS dependencies on WMS_OP_PLAN_DETAILS

Line 110: FROM wms_op_plan_details

106: WHERE operation_plan_id=v_operation_plan_id;
107:
108: CURSOR c_loc_selection_type(v_op_plan_id NUMBER) IS
109: SELECT loc_selection_criteria
110: FROM wms_op_plan_details
111: WHERE operation_sequence=(SELECT MAX(operation_sequence)
112: FROM wms_op_plan_details
113: WHERE operation_plan_id=v_op_plan_id)
114: AND operation_type IN (G_OP_TYPE_DROP,G_OP_TYPE_CROSSDOCK)

Line 112: FROM wms_op_plan_details

108: CURSOR c_loc_selection_type(v_op_plan_id NUMBER) IS
109: SELECT loc_selection_criteria
110: FROM wms_op_plan_details
111: WHERE operation_sequence=(SELECT MAX(operation_sequence)
112: FROM wms_op_plan_details
113: WHERE operation_plan_id=v_op_plan_id)
114: AND operation_type IN (G_OP_TYPE_DROP,G_OP_TYPE_CROSSDOCK)
115: AND operation_plan_id=v_op_plan_id;
116:

Line 123: FROM WMS_OP_PLAN_DETAILS

119: , operation_sequence
120: , is_in_inventory
121: , operation_type
122: , subsequent_op_plan_id
123: FROM WMS_OP_PLAN_DETAILS
124: WHERE operation_plan_id = v_operation_plan_id
125: AND operation_sequence = (SELECT MIN(operation_sequence)
126: FROM WMS_OP_PLAN_DETAILS
127: WHERE operation_plan_id=v_operation_plan_id);

Line 126: FROM WMS_OP_PLAN_DETAILS

122: , subsequent_op_plan_id
123: FROM WMS_OP_PLAN_DETAILS
124: WHERE operation_plan_id = v_operation_plan_id
125: AND operation_sequence = (SELECT MIN(operation_sequence)
126: FROM WMS_OP_PLAN_DETAILS
127: WHERE operation_plan_id=v_operation_plan_id);
128:
129: CURSOR c_plan_instance_exists IS
130: SELECT 1

Line 254: * and query WMS_OP_PLAN_DETAILS (WOPD) for the first (smallest operation_sequence)

250:
251: l_progress:=50;
252:
253: /* Query WMS_OP_PLANS_B for the operation_plan_id of this P_Source_task_ID;
254: * and query WMS_OP_PLAN_DETAILS (WOPD) for the first (smallest operation_sequence)
255: * WOPD record for this plan for the operation_plan_id of this P_Source_task_ID;
256: * Populate PL/SQL records for these two tables.
257: * If Operation_Plan_ID is invalid then raise error exception.
258: */

Line 801: wms_op_plan_details wopd

797: wopd.lpn_selection_api_id lpn_selection_api_id,
798: wopd.operation_type operation_type,
799: nvl(wopd.is_in_inventory,'N') is_in_inventory
800: FROM wms_op_operation_instances wooi,
801: wms_op_plan_details wopd
802: WHERE wooi.activity_type_id = p_activity_type_id
803: AND wooi.source_task_id = p_source_task_id
804: AND wooi.operation_status IN (g_op_ins_stat_pending,g_op_ins_stat_active)
805: AND wooi.operation_plan_detail_id = wopd.operation_plan_detail_id;

Line 1048: FROM wms_op_plan_details

1044: INTO l_xd_loc_selection_criteria
1045: , l_xd_loc_selection_api_id
1046: , l_consolidation_method_id
1047: , l_xd_drop_lpn_option
1048: FROM wms_op_plan_details
1049: WHERE operation_plan_id = l_mmtt_data_rec.operation_plan_id
1050: AND operation_type = 2;
1051: EXCEPTION
1052: WHEN OTHERS THEN

Line 1721: wms_op_plan_details wopd

1717: mmtt.primary_quantity,
1718: mmtt.move_order_line_id
1719: FROM mtl_material_transactions_temp mmtt,
1720: wms_op_operation_instances wooi,
1721: wms_op_plan_details wopd
1722: WHERE mmtt.transaction_temp_id=p_source_task_id
1723: AND mmtt.transaction_temp_id = wooi.source_task_id (+)
1724: AND wooi.operation_plan_detail_id = wopd.operation_plan_detail_id(+);
1725:

Line 2582: wms_op_plan_details wopd

2578: wooi.sug_to_locator_id,
2579: wooi.organization_id,
2580: wopd.operation_plan_id
2581: FROM wms_op_operation_instances wooi,
2582: wms_op_plan_details wopd
2583: WHERE wooi.source_task_id = p_source_task_id
2584: AND wooi.activity_type_id = p_activity_id
2585: AND wooi.operation_plan_detail_id = wopd.operation_plan_detail_id
2586: ORDER BY wooi.operation_sequence DESC,

Line 2601: FROM wms_op_plan_details wopd1,

2597: , wopd1.operation_sequence
2598: , wopd1.is_in_inventory
2599: , wopd1.operation_type
2600: , Decode(Nvl(wopb.crossdock_to_wip_flag, 'N'),'N', Nvl(wopd1.subsequent_op_plan_id, 1),v_operation_plan_id) subsequent_op_plan_id-- added for planned xdocking
2601: FROM wms_op_plan_details wopd1,
2602: wms_op_plans_b wopb
2603: WHERE wopd1.operation_plan_id = v_operation_plan_id
2604: AND wopb.operation_plan_id = v_operation_plan_id
2605: AND wopd1.operation_sequence = (SELECT MIN(wopd2.operation_sequence)

Line 2606: FROM wms_op_plan_details wopd2

2602: wms_op_plans_b wopb
2603: WHERE wopd1.operation_plan_id = v_operation_plan_id
2604: AND wopb.operation_plan_id = v_operation_plan_id
2605: AND wopd1.operation_sequence = (SELECT MIN(wopd2.operation_sequence)
2606: FROM wms_op_plan_details wopd2
2607: WHERE wopd2.operation_plan_id = v_operation_plan_id
2608: AND (wopd2.operation_sequence > v_current_detail_sequence -- operations after the current
2609: OR (wopd2.operation_type = g_op_type_crossdock -- when current is a load operation for crossdock, sequence can be same as current operation
2610: AND wopd2.operation_sequence = v_current_detail_sequence)

Line 3102: FROM wms_op_plan_details wopd1

3098: l_progress := 104;
3099:
3100: SELECT MAX(wopd1.operation_sequence)
3101: INTO l_last_op_sequence
3102: FROM wms_op_plan_details wopd1
3103: WHERE wopd1.operation_plan_id =
3104: (SELECT wopd2.operation_plan_id
3105: FROM wms_op_plan_details wopd2
3106: WHERE wopd2.operation_plan_detail_id = l_wooi_data_rec.operation_plan_detail_id

Line 3105: FROM wms_op_plan_details wopd2

3101: INTO l_last_op_sequence
3102: FROM wms_op_plan_details wopd1
3103: WHERE wopd1.operation_plan_id =
3104: (SELECT wopd2.operation_plan_id
3105: FROM wms_op_plan_details wopd2
3106: WHERE wopd2.operation_plan_detail_id = l_wooi_data_rec.operation_plan_detail_id
3107: );
3108:
3109: l_progress := 106;

Line 3182: FROM wms_op_plan_details

3178: loc_selection_api_id
3179: INTO
3180: l_loc_sel_criteria_id,
3181: l_loc_sel_api_id
3182: FROM wms_op_plan_details
3183: WHERE operation_plan_detail_id = l_wooi_data_rec.operation_plan_detail_id;
3184: l_progress := 110;
3185:
3186: IF (l_debug=1) THEN

Line 4085: wms_op_plan_details wopd

4081: CURSOR c_operation_instance(v_source_task_id NUMBER) IS
4082: SELECT wopi.operation_type_id,
4083: wopd.operation_type wopd_op_type_id
4084: FROM wms_op_operation_instances wopi,
4085: wms_op_plan_details wopd
4086: WHERE wopi.source_task_id = v_source_task_id
4087: AND wopi.operation_status IN (G_OP_INS_STAT_PENDING,G_OP_INS_STAT_ACTIVE)
4088: AND wopi.operation_plan_detail_id = wopd.operation_plan_detail_id
4089: ORDER BY wopi.operation_sequence DESC;

Line 6603: FROM wms_op_plan_details wopd1

6599: l_progress := 130;
6600:
6601: SELECT MIN(wopd1.operation_sequence)
6602: INTO l_first_op_sequence
6603: FROM wms_op_plan_details wopd1
6604: WHERE wopd1.operation_plan_id =
6605: (SELECT wopd2.operation_plan_id
6606: FROM wms_op_plan_details wopd2
6607: WHERE wopd2.operation_plan_detail_id = l_wooi_data_rec.operation_plan_detail_id

Line 6606: FROM wms_op_plan_details wopd2

6602: INTO l_first_op_sequence
6603: FROM wms_op_plan_details wopd1
6604: WHERE wopd1.operation_plan_id =
6605: (SELECT wopd2.operation_plan_id
6606: FROM wms_op_plan_details wopd2
6607: WHERE wopd2.operation_plan_detail_id = l_wooi_data_rec.operation_plan_detail_id
6608: );
6609:
6610: l_progress := 140;

Line 7864: FROM wms_op_plan_details

7860: ORDER BY 4;
7861:
7862: CURSOR c_min_operation_seq (v_op_plan_id NUMBER) IS
7863: SELECT MIN(operation_sequence)
7864: FROM wms_op_plan_details
7865: WHERE operation_plan_id = v_op_plan_id;
7866:
7867:
7868: