DBA Data[Home] [Help]

APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on STANDARD

Line 3169: , t.standard_operation_id

3165: --Step0 Get reources information
3166: -- Picking or Replenishment task
3167: SELECT bremp.resource_id role_id
3168: , t.wms_task_type
3169: , t.standard_operation_id
3170: , t.operation_plan_id
3171: INTO l_per_res_id
3172: , l_wms_task_type
3173: , l_std_op_id

Line 3177: AND t.standard_operation_id = bsor.standard_operation_id

3173: , l_std_op_id
3174: , l_operation_plan_id
3175: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
3176: WHERE t.transaction_temp_id = l_rec.task_id
3177: AND t.standard_operation_id = bsor.standard_operation_id
3178: AND bsor.resource_id = bremp.resource_id
3179: AND bremp.resource_type = 2
3180: AND ROWNUM < 2;
3181: