APPS.WMS_ATF_RUNTIME_PUB_APIS dependencies on WMS_OP_PLANS_B

Line 105: FROM WMS_OP_PLANS_B

101: WHERE transaction_temp_id=p_source_task_id;
102:
103: CURSOR c_operation_plan(v_operation_plan_id NUMBER) IS
104: SELECT plan_type_id, crossdock_to_wip_flag
105: FROM WMS_OP_PLANS_B
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

Line 253: /* Query WMS_OP_PLANS_B for the operation_plan_id of this P_Source_task_ID;

249: END IF;
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.

Line 814: wms_op_plans_b wopb

810: SELECT mol.project_id, mol.task_id,mmtt.organization_id, mmtt.operation_plan_id, mmtt.lpn_id,
811: Nvl(wopb.crossdock_to_wip_flag, 'N') crossdock_to_wip_flag
812: FROM mtl_material_transactions_temp mmtt,
813: mtl_txn_request_lines mol,
814: wms_op_plans_b wopb
815: WHERE mmtt.move_order_line_id = mol.line_id
816: AND mmtt.operation_plan_id = wopb.operation_plan_id
817: AND mmtt.transaction_temp_id = p_source_task_id;
818:

Line 2602: wms_op_plans_b wopb

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)
2606: FROM wms_op_plan_details wopd2