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 2619: wms_op_plan_details wopd

2615: wooi.sug_to_locator_id,
2616: wooi.organization_id,
2617: wopd.operation_plan_id
2618: FROM wms_op_operation_instances wooi,
2619: wms_op_plan_details wopd
2620: WHERE wooi.source_task_id = p_source_task_id
2621: AND wooi.activity_type_id = p_activity_id
2622: AND wooi.operation_plan_detail_id = wopd.operation_plan_detail_id
2623: ORDER BY wooi.operation_sequence DESC,

Line 2638: FROM wms_op_plan_details wopd1,

2634: , wopd1.operation_sequence
2635: , wopd1.is_in_inventory
2636: , wopd1.operation_type
2637: , 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
2638: FROM wms_op_plan_details wopd1,
2639: wms_op_plans_b wopb
2640: WHERE wopd1.operation_plan_id = v_operation_plan_id
2641: AND wopb.operation_plan_id = v_operation_plan_id
2642: AND wopd1.operation_sequence = (SELECT MIN(wopd2.operation_sequence)

Line 2643: FROM wms_op_plan_details wopd2

2639: wms_op_plans_b wopb
2640: WHERE wopd1.operation_plan_id = v_operation_plan_id
2641: AND wopb.operation_plan_id = v_operation_plan_id
2642: AND wopd1.operation_sequence = (SELECT MIN(wopd2.operation_sequence)
2643: FROM wms_op_plan_details wopd2
2644: WHERE wopd2.operation_plan_id = v_operation_plan_id
2645: AND (wopd2.operation_sequence > v_current_detail_sequence -- operations after the current
2646: OR (wopd2.operation_type = g_op_type_crossdock -- when current is a load operation for crossdock, sequence can be same as current operation
2647: AND wopd2.operation_sequence = v_current_detail_sequence)

Line 3142: FROM wms_op_plan_details wopd1

3138: l_progress := 104;
3139:
3140: SELECT MAX(wopd1.operation_sequence)
3141: INTO l_last_op_sequence
3142: FROM wms_op_plan_details wopd1
3143: WHERE wopd1.operation_plan_id =
3144: (SELECT wopd2.operation_plan_id
3145: FROM wms_op_plan_details wopd2
3146: WHERE wopd2.operation_plan_detail_id = l_wooi_data_rec.operation_plan_detail_id

Line 3145: FROM wms_op_plan_details wopd2

3141: INTO l_last_op_sequence
3142: FROM wms_op_plan_details wopd1
3143: WHERE wopd1.operation_plan_id =
3144: (SELECT wopd2.operation_plan_id
3145: FROM wms_op_plan_details wopd2
3146: WHERE wopd2.operation_plan_detail_id = l_wooi_data_rec.operation_plan_detail_id
3147: );
3148:
3149: l_progress := 106;

Line 3222: FROM wms_op_plan_details

3218: loc_selection_api_id
3219: INTO
3220: l_loc_sel_criteria_id,
3221: l_loc_sel_api_id
3222: FROM wms_op_plan_details
3223: WHERE operation_plan_detail_id = l_wooi_data_rec.operation_plan_detail_id;
3224: l_progress := 110;
3225:
3226: IF (l_debug=1) THEN

Line 4125: wms_op_plan_details wopd

4121: CURSOR c_operation_instance(v_source_task_id NUMBER) IS
4122: SELECT wopi.operation_type_id,
4123: wopd.operation_type wopd_op_type_id
4124: FROM wms_op_operation_instances wopi,
4125: wms_op_plan_details wopd
4126: WHERE wopi.source_task_id = v_source_task_id
4127: AND wopi.operation_status IN (G_OP_INS_STAT_PENDING,G_OP_INS_STAT_ACTIVE)
4128: AND wopi.operation_plan_detail_id = wopd.operation_plan_detail_id
4129: ORDER BY wopi.operation_sequence DESC;

Line 6733: FROM wms_op_plan_details wopd1

6729: l_progress := 130;
6730:
6731: SELECT MIN(wopd1.operation_sequence)
6732: INTO l_first_op_sequence
6733: FROM wms_op_plan_details wopd1
6734: WHERE wopd1.operation_plan_id =
6735: (SELECT wopd2.operation_plan_id
6736: FROM wms_op_plan_details wopd2
6737: WHERE wopd2.operation_plan_detail_id = l_wooi_data_rec.operation_plan_detail_id

Line 6736: FROM wms_op_plan_details wopd2

6732: INTO l_first_op_sequence
6733: FROM wms_op_plan_details wopd1
6734: WHERE wopd1.operation_plan_id =
6735: (SELECT wopd2.operation_plan_id
6736: FROM wms_op_plan_details wopd2
6737: WHERE wopd2.operation_plan_detail_id = l_wooi_data_rec.operation_plan_detail_id
6738: );
6739:
6740: l_progress := 140;

Line 7994: FROM wms_op_plan_details

7990: ORDER BY 4;
7991:
7992: CURSOR c_min_operation_seq (v_op_plan_id NUMBER) IS
7993: SELECT MIN(operation_sequence)
7994: FROM wms_op_plan_details
7995: WHERE operation_plan_id = v_op_plan_id;
7996:
7997:
7998: